1. LCase VBA function – Description
The LCase VBA function converts all letters in a string to lowercase. This can be compared to the LOWER function in an Excel worksheet. How to use LCASE function in VBA Excel? In the argument of the function, enter a string in quotation marks, or refer to any text variable String. The functions can be compared to the LowerCase or Lower functions in other programming languages.
2. VBA LCase function – Syntax
String – The text string in which we want to convert all letters to lowercase
Function return: String / text value
3. VBA LCase function – Example
How to use LCASE function in VBA Excel? Below is an example of using the LCASE function in the VisualBasic Editor.
Sub LCaseExample () MsgBox LCase ("Learning Function") Range ("A1") = LCase ("Learning Function") End Sub
4. LCase VBA function – Where to use?
The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.
The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address: VBA functions