Excel VBA UCase Function

The UCase function in VBA converts a String into upper case text.

Syntax

UCase (String)

Parameter

String (required) – This parameter represents the string that you want to convert to upper case.

Return

This function returns a string after converting the given string into upper case text.

Example 1

Sub UCaseFunction_Example1()
 ' Converting the string str to upper case text.
 Dim str As String, str1 As String
 str = "Welcome to VBA World!"
 str1 = UCase(str)
 ' The variable str1 will return "WELCOME TO VBA WORLD!" 
 ActiveCell.Value = str1
 End Sub 

Output

WELCOME TO VBA WORLD!

Example 2

Sub UCaseFunction_Example2()
 ' Converting the string str to upper case text.
 Dim str As String, str1 As String
 str = "HeLlo WORLd. I am 22! " 
 str1 = UCase(str)
 ' The variable str1 will return "HELLO WORLD. I AM 22!"
 ActiveCell.Value = str1
 End Sub 

Output

HELLO WORLD. I AM 22!