Excel VBA Macros for Beginners- How To Change The Text To Upper Case Or Lower Case

Excel VBA Macros for Beginners- How To Change The Text To Upper Case Or Lower Case

This example will help you to change the text from lower case to upper case. We use Upper Case Function to do this. If you want to change the text or string from upper case to lower case. we can use Lower Case function.Untitled section

Sub sbExample() 'You can use upper Case function to change the text into Upper Case Range("C2").Value = UCase(Range("C2").Value) End Sub

Sub sbExample() 'You can use Lower Case function to change the text into lowerCase Range("C3").Value = LCase(Range("C3").Value) End Sub