Excel VBA Macro for Upper Case Text Formatting

Richard Binning

Heat a tablespoon viagra discount india of oil in a pressure pan. They are expert in pharmacy dropshipping business and doing their business all across the tadalafil price in india country. For example, during the World Cup 2006 the sale of impotence treatments have a peek here order viagra on line were noticeable altered by the routine of your food consumption. It Get More Info discount viagra usa empties mind of negative energy and increases the blood flow there without affecting other parts of body.

I find myself updating some documentation for the menu system I enhanced yesterday. While updating a spreadsheet, I spied the following vba macro. I thought you might find it handy for formatting selected cells.

Place the following in your “ThisWorkbook” module inside the vba editor.

Option Explicit

Sub Upper_Case()
‘
‘ Upper_Case Macro
‘ Change Value of Selection to upper case
‘
‘ Keyboard Shortcut: Ctrl+t
‘
Dim myCell As Range
Set myCell = Application.ActiveCell
With myCell
.Select
.Value = UCase(.Text)
End With
End Sub

Then assign a shortcut to run the routine. (I use Ctrl+Shift+T) Then as you work in excel, you can select a cell that you want to format as upper case text and press your shortcut to reformat it.

…now back to work!

Leave a Reply