D
Devvy D
Hi there!
When user enters some text in a cell, I use macros to validate.
If there are some incorrect data I want to correct this
programmatically. So I use the SheetChange event.
The problem is that when I correct what the user entered, the event
is fired once again, and then again and again and again... I think you
understand the problem...
How can I work around this problem, is it for example possible to
temporarily disable the event?
Best Regards
L-E
When user enters some text in a cell, I use macros to validate.
If there are some incorrect data I want to correct this
programmatically. So I use the SheetChange event.
The problem is that when I correct what the user entered, the event
is fired once again, and then again and again and again... I think you
understand the problem...
How can I work around this problem, is it for example possible to
temporarily disable the event?
Best Regards
L-E