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

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

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

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


On Tue, 19 May 2009 09:16:01 -0700, Lynda
wrote:

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