Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use the Worksheet_Change(ByVal Target AS Excel.Range) event to update input values (I replace "-" character with 0) on Office 97 (NT4)
For most of the computers, the Target.Value is equal to the value But on some computer the new value is not available. Indeed, the Target.Value is still equal to previous value of the cell Example So when I have a cell equal to The user inputs 1 The event replaces the - with 0 instead of keeping 1 What's the problem? Thanks for email me your response to Many thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disabling WORKSHEET_CHANGE event | Excel Discussion (Misc queries) | |||
Controling the Worksheet_Change Event? | Excel Discussion (Misc queries) | |||
Worksheet_Change Event | Excel Programming | |||
xl97 and Worksheet_Change event ? | Excel Programming | |||
Worksheet_Change Event Not Working | Excel Programming |