MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re: Capitalization

Posted by Gary Ford on December 05, 2001 4:02 AM

How can I set some cells to be always set text as Capitals

Posted by Hodge on December 05, 2001 6:06 AM

Include this code in the workbooks Change Event macro . . .

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = UCase(Target.Value)
End Sub