VBA LCase function

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 4.00 out of 5)
Loading...

LCase Function Description

The VBA LCase function converts a string to lower-case. All upper-case letters are converted to lower case.

Use UCase to convert a string to upper-case letters instead.

Syntax

The syntax for the LCase function in VBA is:

LCase( text )

Parameters

text
The text string that you wish to convert to lower-case letters.

Example usage

The LCase function can only be used in VBA code. Let’s look at some VBA LCase function examples:

LCase "Hello There!"
'Result: "hello there!"

LCase "WOW"
'Result: "wow"

Simply the best place to learn Excel VBA