VBA LCASE Function (Syntax + Example)


- Written by Puneet (Last Updated: June 22, 2023)

The VBA LCASE function is listed under the text category of VBA functions. When you use it in VBA code, it converts the supplied string into a lower case string. In simple words, a lower case string is where you have all the characters in lower case. It works like the LOWER function in the worksheet.




  • String: The string value which you want to convert into lower case.


To practically understand how to use the VBA LCASE function, you need to go through the below example where we have written a vba code by using it:

Sub example_LCASE()
Range("B1").Value = LCase(Range("A1"))    
End Sub

In the above code, we have used the LACSE to convert the string which we have in cell A1 into a lower-case string where all the letters are as small letters.


  • LCASE doesn’t make any changes in punctuation and numbers.
Last Updated: June 22, 2023