Excel: UCase Function (VBA only)

In Excel, the UCase function converts a string to all upper-case.

The syntax for the UCase function is:

UCase( text )

text is the string that you wish to convert to upper-case.

Applies To:

For example:

UCase("Tech on the Net") would return "TECH ON THE NET"

UCase("Alphabet") would return "ALPHABET"

VBA Code

The UCase function can only be used in VBA code. For example:

Dim LResult As String

LResult = UCase("This is a TEST")

In this example, the variable called LResult would now contain the value "THIS IS A TEST".