LCase, LCase$ Functions

Named Arguments





Use: Required

Data Type: String

A valid string expression.

Return Value

LCase$ returns a String, and LCase returns a variant of subtype String.


Converts a string to lowercase.

Rules at a Glance

  • LCase affects only uppercase letters; all other characters in string are unaffected.

  • LCase returns Null if string contains a Null.

Programming Tips and Gotchas

As with all string functions for which two variations are available (one suffixed with the $ sign and one without a $), the $ version returns a String data type, while the plain version returns a variant of subtype String.

See Also

UCase Function

Get VB & VBA in a Nutshell: The Language now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.