A
Arlene
Just for cosmetic purposes is there anyway to set the input on a cell so that
no matter how something is entered it shows as a capital.
no matter how something is entered it shows as a capital.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wigi
Sorry, I meant Worksheet_Change event.
W
Wigi
You would need a Selection_Change event in VBA to capture that. Search the NG
for code, it's often posted.
for code, it's often posted.
G
Gord Dibben
"Cosmetics"
All caps would look horrible to me and make things hard to read but....
This event code will do the trick.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 8 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub
Works on columns A:H........change the >8 to whatever you wish.
Right-click on the sheet tab and "View Code"
Copy/paste the code into that sheet module.
Close the VBE and save the workbook.
Gord Dibben MS Excel MVP
All caps would look horrible to me and make things hard to read but....
This event code will do the trick.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 8 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub
Works on columns A:H........change the >8 to whatever you wish.
Right-click on the sheet tab and "View Code"
Copy/paste the code into that sheet module.
Close the VBE and save the workbook.
Gord Dibben MS Excel MVP
A
Arlene
Thanks Gord; the all caps is for a specific input cell, the thing described
is done with caps. Thanks for the problem solve, I really did not think it
could be done.
is done with caps. Thanks for the problem solve, I really did not think it
could be done.