VBA Function: UCase

The VBA UCase function converts a string to uppercase.

Usage:

UCase(text)

Example of Usage

Converting a string to uppercase:

Sub example()
    
    referenceNumber = "Ref-45-X-876-rt"
    
    referenceNumber = UCase(referenceNumber)
    
    MsgBox referenceNumber 'Returns: REF-45-X-876-RT
    
End Sub

The inverse function that converts to lowercase is the LCase function.