Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change cell value to uppercase automaticaly when entered
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change cell value to uppercase automaticaly when entered
indy, something like this, put in worksheet code,
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Error_handler If Not Intersect(Range("A1"), Target) Is Nothing Then With Target If Not .HasFormula Then Application.EnableEvents = False .Value = UCase(.Value) End If End With End If Error_handler: Resume Next Application.EnableEvents = True End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "indy" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) |