VBA UCase function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

UCase Function Description

The VBA UCase function converts a string to upper-case. All lower-case letters are converted to upper-case.

Use LCase to convert a string to upper-case letters instead.


The syntax for the UCase function in VBA is:

UCase( text )


The text string that you wish to convert to upper-case letters.

Example usage

The UCase function can only be used in VBA code. Let’s look at some VBA UCase function examples:

UCase "Hello There!"
'Result: "HELLO THERE!"

UCase "wow"
'Result: "WOW"

Simply the best place to learn Excel VBA