Make all text in MS Excel 2013 capitalized using a VBA script

first off…
Show the Developer tab
– Click the File tab
– Click Options
– Click Customize Ribbon
– Under Customize the Ribbon and under Main Tabs, select the Developer check box.
….now you have this
excel bar_dev-tab

Create a macro by using VBA
On the Developer tab, in the Code group, click Visual Basic.
If needed, in the Visual Basic Editor, on the Insert menu, click Module.
NOTE Modules are automatically created for all sheets in the workbook.

– In the code window of the module, type or copy the macro code* that you want to use.
– To run the macro from the module window, press F5.
– In the Visual Basic Editor, on the File menu, click Close and Return to Microsoft Excel when you finish writing the macro.

Sub Uppercase()
For Each x In Selection
x.Value = UCase(x.Value)
End Sub

you are awesome!
you are awesome!