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.

Syntax

The syntax for the UCase function in VBA is:

UCase( text )

Parameters

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"