LCase VBA function – How to use the LCase function

Last Updated on January 11, 2023 by token

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

LCase (String)

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
Excel VBA functions - LCase VBA function
Excel VBA functions – LCase VBA function

4. LCase VBA function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: