| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change event fails to work
In the change event handler I call a simple function that removes unwanted
characters from a string value, then returns the string. Simple huh? Well I'm using Excel 2000 and this fails to work. Any reason why? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Target.Value = CheckString(Target.Value) Application.EnableEvents = True End Sub Thanks. Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup doesn't work until i edit(but not change) the lookup cell | Excel Worksheet Functions | |||
| Hyperlinks change path on save in Excel 2003 | Excel Worksheet Functions | |||
| How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) | |||
| Change cell back color on click | Excel Discussion (Misc queries) | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
Threaded Mode
