Excel VBA Macro for Upper Case Text Formatting

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
.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!

Daylight Savings Time comes early this year!

If you do nothing else to prepare for the 3 week early Daylight Savings Time adjustment, at least put the date and time in the subject line on any notices, appointments, and/or meeting requests you schedule. During the advance period of March 11th to March 25th, not everyone’s calendar will be behaving as expected. Do yourself and those you meet with a favor. Check your calendars frequently and place the date and time of the meeting in the subject line. You’ll be glad you did.

DST commonly begins in the northern hemisphere on the last Sunday in March or the first Sunday in April and ends on the last Sunday in October. However, due to the Energy Policy Act of 2005, beginning in 2007, the United States will begin observing DST from the second Sunday in March until the first Sunday in November. (Studies will determine if this remains permanent.)” – Wikipedia

Here are some links to information that will help with your DST adjustments:

Microsoft Discussion
Windows XP (SP2) – KB 928388
Windows XP (SP1) – Not Supported
Windows Server 2003 – KB 928388
Windows 2000 – Apply TZEDIT.EXE manually
Windows NT4 – Not Supported
Microsoft Outlook – Check the Microsoft Download Center
Windows Mobile Devices – Microsoft KB Article 923953
Windows CE – KB 923027

Hope that helps