See Also Example
Returns a string in which all letters of an argument have been converted to lowercase.
Syntax
LCase[$](strexpr)
Remarks
LCase returns a Variant
The argument strexpr can be any string expression However, only LCase can accept a Variant of VarType 1 (Null ) as strexpr, in which case, a Null is returned.
Only uppercase letters are converted to lowercase; all lowercase letters and nonletter characters remain unchanged.
UCase, UCase$ Function
LCase, LCase$ Function Example
The example uses LCase to return an all-lowercase version of the argument string. To try this example, paste the code into the Declarations section of a form. Then press F5 and click the form.
Sub Form_Click ()
Dim Lowercase, Msg, Uppercase ' Declare variables.
Uppercase = "ONCE UPON A TIME" ' String to convert.
Lowercase = LCase(UpperCase) ' Convert to lowercase.
Msg = "LCase converts """ & Uppercase & """ to """
Msg = Msg & Lowercase & "."""
MsgBox Msg ' Display message.
End Sub