VBA LCase

Excel VBA LCase Function

In this article, we will discuss changing the text value to lower case. We can do this by the LCase function in VBA. Similar to the UCase, LCase changes the upper case characters to lower case characters in VBA. The syntax will be as follows to use Lcase function in VBA:

Syntax of LCase in Excel VBA

The syntax for the LCase function excel VBA is as follows:

The string is the input we provide to the function. The input can be a single cell or a group of cells or a whole cell range. If we use Lcase it only changes the text into the lower case but it does not change the structure of the text. For example, if we have a semicolon or a comma in our text it remains untouched. For example, if we input Lcase ( EVERYTHING ) the result we will have is everything. Secondly, in an example, if we have an input such as Lcase (ANAND, ARAN / NEERAJ ) the result will be as follows: Anand, aran / Neeraj.

Let us use this function in a few examples which will provide a better thought process about the function.

How to Use Excel VBA LCase Function?

We will learn how to use a VBA LCase with few examples in Excel.

VBA LCase Function – Example #1

I have a string inside a cell A1 of sheet 1. The string is in the upper case we will convert it to lower case by Lcase function. Have a look at the string below.

Follow the below steps to use LCase in Excel VBA.

Step 1: We start by going to the developer’s tab to open VB Editor from a Visual Basic Option.

Step 2: Now click on the insert tab which will show us to insert a module in the VBA. To start writing the code double click on the module.

Step 3: Then declare a macro Sub Function.

Code:

Sub Sample()

End Sub

Step 4: To use any of the sheet properties we need to activate the sheet first.

Code:

Sub Sample()

Worksheets("Sheet1").Activate

End Sub

Step 5: Now let us change the value in cell A1 by using the LCase Function as follows.

Code:

Sub Sample()

Worksheets("Sheet1").Activate
Range("A1").Value = LCase(Range("A1"))

End Sub

Step 6: When we run the above code we get the following result.

In the above example, we have changed the text from upper case to lower case using Lcase function.

VBA LCase Function – Example #2

Let us take input from the user in the Upper case and change the value of text to lower case using the Lcase function.

Step 1: Again we start by going in VB Editor from Visual Basic under the developer’s tab.

Step 2: Click on Insert tab and add a new module

Step 3: Declare a second macro different from the first one as two macros cannot have the same name.

Code:

Sub Sample1()

End Sub

Step 4: Use Dim to declare two variables A and B as String.

Code:

Sub Sample1()

Dim A, B As String

End Sub

Step 5: Use the Inputbox function to take input from the user and store the value in variable A.

Code:

Sub Sample1()

Dim A, B As String
A = InputBox("Write a string", "In Uppercase")

End Sub

Step 6: In B store the value of the Input string is changed from upper case to lower case using Lcase function.

Code:

Sub Sample1()

Dim A, B As String
A = InputBox("Write a string", "In Uppercase")
B = LCase(A)

End Sub

Step 7: Use the Msgbox Function to display the result.

Code:

Sub Sample1()

Dim A, B As String
A = InputBox("Write a string", "In Uppercase")
B = LCase(A)
MsgBox B

End Sub

Step 8: Run the above code by pressing F5 and we get a prompt to give a value. Input any string. Click on OK to see the result.

VBA LCase Function – Example #3

Above we have discussed how this Lcase function does not affect the structure of the string i.e. if there is a comma or a semicolon or any other special character it remains unaffected. For demonstration, I have a string in cell C1 with some special characters in it. It is as below,

Step 1: Again we start by going in VB Editor from Visual Basic under the developer’s tab.

Step 2: Click on Insert and add module above let us write the code in the same module.

Step 3: Declare a third macro name using the Sub Function.

Code:

Sub Sample2()

End Sub

Step 4: In order to use the string in cell C1, we need to activate the sheet 1 first.

Code:

Sub Sample2()

Worksheets("Sheet1").Activate

End Sub

Step 5: Now let us use the LCase function on cell C1 to check whether it affects the special characters or not.

Code:

Sub Sample2()

Worksheets("Sheet1").Activate
Range("c1").Value = LCase(Range("c1"))

End Sub

Step 6: Execute the above code by using the run button and see the following result.

We can see that Lcase does not affect any of the special characters in the string.

VBA LCase Function – Example #4

Now in this example let us change a range of data from upper case to lower case using the LCase function. For demonstration, my data is in Sheet 2 which is as follows,

I want to change the strings in column A which are in upper case to lower case in column B.

Step 1: Click on the Insert Tab and add Module

Step 2: Declare a macro name for this example.

Code:

Sub Sample3()

End Sub

Step 3: Activate sheet 2 first so that we can use its properties.

Code:

Sub Sample3()

Worksheets("Sheet2").Activate

End Sub

Step 4: Declare a variable A and its data type as long.

Code:

Sub Sample3()

Worksheets("Sheet2").Activate
Dim A As Long

End Sub

Step 5: Now we will use for loop to loop the next data in the next row.

Code:

Sub Sample3()

Worksheets("Sheet2").Activate
Dim A As Long
For A = 2 To 6

End Sub

Step 6: Let us change the value in column A to lower case and store it in column B by the following code.

Code:

Sub Sample3()

Worksheets("Sheet2").Activate
Dim A As Long
For A = 2 To 6
Cells(A, 2).Value = LCase(Cells(A, 1).Value)

End Sub

Step 7: Loop until the last row is found,

Code:

Sub Sample3()

Worksheets("Sheet2").Activate
Dim A As Long
For A = 2 To 6
Cells(A, 2).Value = LCase(Cells(A, 1).Value)
Next A

End Sub

Step 8: When we run the above code we get the following result.

Things to Remember

• Lcase changes text to lower case.
• The input we provide to the function can be a single cell or range of cells.
• If the input function has any special symbols or characters it remains unchanged.

Recommended Articles

This is a guide to VBA LCase. Here we discuss how to use Excel VBA LCase Function along with practical examples and downloadable excel template. You can also go through our other suggested articles –

1. VBA InStr explained with Examples
2. VBA Integer Data Type
3. How to Select Cell using VBA Code?
4. Transpose a Range in VBA