Excel automatically capitalize text in a column

Posted by A.R. on August 17, 2001 10:40 AM

I have columns in Excel where have to enter a letter (using A,B,C, as codes). The letter has to be capitalized and is there a way for Excel to automatically capitalized for a particular column. For example, instead of pressing shift and the letter all I do is just type the letter and it will capitalize that letter.

Posted by Robb on August 17, 2001 6:49 PM

Try this in the Worksheet Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("C")) Is Nothing Then
Target = Format(Target, ">")
Else
End If
End Sub

This formats Column C - you'll have to amend to suit.

Does it help?