Posted to microsoft.public.excel.programming
|
|
Can I stop the change event being triggered?
Thanks - great
M
"Jan Karel Pieterse" wrote in message
...
Hi Michelle,
On my user form, I want Control1 to effect the value of Control2, but
when
it does, I don't want the change event for Control2 to be triggered.
Enable events doesn't work
Can I temporarily switch off the change event, then change the control
then
switch it back on?
See:
http://www.jkp-ads.com/Articles/NoEvents00.asp
Regards,
Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
|