Home / VBA / Top VBA Functions / VBA LCASE Function (Syntax + Example)

VBA LCASE Function (Syntax + Example)

- Written by Puneet

Contents hide
Syntax
Arguments
Example
Notes

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.

Syntax

LCase(String)

Arguments

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

Example

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:

example-vba-lcase-function
Sub example_LCASE()
Range("B1").Value = LCase(Range("A1"))    
End Sub

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

Notes

  • LCASE doesn’t make any changes in punctuation and numbers.