Visual Basic for Applications Reference
UCase Function Example
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".