If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|