You can use the UCase function in VBA to convert strings to uppercase.
You can use the following syntax to convert a range of cells with strings to uppercase:
Sub ConvertToUpperCase()
Dim i As Integer
For i = 2 To 10
Range("B" & i) = UCase(Range("A" & i))
Next i
End Sub
This particular example will convert each string in the range A2:A10 to uppercase and display the results in the range B2:B10.
The following example shows how to use this syntax in practice.
Example: Convert Strings to Uppercase Using VBA
Suppose we have the following column of strings in Excel:
Suppose we would like to convert each string in column A to uppercase and display the results in column B:
We can create the following macro to do so:
Sub ConvertToUpperCase()
Dim i As Integer
For i = 2 To 10
Range("B" & i) = UCase(Range("A" & i))
Next i
End Sub
When we run this macro, we receive the following output:
Column B displays each string in column A in uppercase.
Note: You can find the complete documentation for the UCase function in VBA here.
Additional Resources
The following tutorials explain how to perform other common tasks in VBA:
How to Compare Strings in VBA
How to Remove Spaces from String in VBA
How to Replace Characters in String in VBA