VBA LCASE Function (Syntax + Example)

HomeVBA TutorialTop VBA FunctionsVBA LCASE Function (Syntax + Example)

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 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 the cell A1 into a lower case string where all the letters are as small letters.

Notes

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

Related Functions

FORMAT | INSTR | INSTRREV | LEFT | LEN | LTRIM | MID | REPLACE | RIGHT | RTRIM | SPACE | STRCOMP | STRCONV | STRING | STRREVERSE | TRIM | UCASE