Excel VBA LCase Function
VBA LCase Function: The LCase function in VBA converts the given String into lower case text.
Syntax
LCase (String)
Parameter
String (required)- This parameter represents the text string that you want to convert to lower case.
Return
This function returns a string after converting it to lower case.
Example 1
Sub LCaseFunction_Example1() ' Converting the string str to lower case text. Dim str As String, str1 As String str = "Welcome to VBA World!" str1 = LCase(str) ' The variable str1 will return "welcome to vba world!" ActiveCell.Value = str1 End Sub
Output
welcome to vba world!
Example 2
Sub LCaseFunction_Example2() ' Converting the string str to lower case text. Dim str As String, str1 As String str = "Heelo WORLd. I am 22! " str1 = LCase(str) ' The variable str1 will return "heelo world. i am 22!" ActiveCell.Value = str1 End Sub
Output
heelo world. i am 22!