Re: Capitalization Home Board Archive Index Excel VBA 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