UCase function
Returns a Variant (String) containing the specified string, converted to uppercase.
UCase(string)
The required string argument is any valid string expression. If string contains Null, Null is returned.
Only lowercase letters are converted to uppercase; all uppercase letters and nonletter characters remain unchanged.
This example uses the UCase function to return an uppercase version of a string.
Dim LowerCase, UpperCase
LowerCase = "Hello World 1234" ' String to convert.
UpperCase = UCase(LowerCase) ' Returns "HELLO WORLD 1234".
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.