Can a column be formated to make any entry in that column capitali

L

Lynda

If there is an entry in that column then it will always be an X. It needs to
be capitalized. If there a way to just enter X and not shift X?
Microsoft Office 2007
 
G

Gord Dibben

Not without using VBA event code for an in-cell change or a helper column
and the UPPER function.

Event code for in-cell-as-you-enter change..................

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 1 Then Exit Sub 'adjust column number to suit
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Helper column..................

In an adjacent column enter =IF(A1="","",UPPER(A1))


Gord Dibben MS Excel MVP
 
Top