Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to format cells in upercase entry
Hi
I read the post for this question (8/8/2006) and Gord Dibben's answer works great. Original Question: I need to format a column so that all cell force any text entry to uppercase. Gord Dibben's Answer: 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 This code allows all columns up to column 8 (column H) to be affected What I would like to know is can I nominate a particular column that this works on. For example I would like only column M to be affected Thanks JOhn |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to format cells in upercase entry
Thanks everyone, but I have worked it out
John "John Calder" wrote: Hi I read the post for this question (8/8/2006) and Gord Dibben's answer works great. Original Question: I need to format a column so that all cell force any text entry to uppercase. Gord Dibben's Answer: 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 This code allows all columns up to column 8 (column H) to be affected What I would like to know is can I nominate a particular column that this works on. For example I would like only column M to be affected Thanks JOhn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
Why will my cells not format? | New Users to Excel | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
format cells having text | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |