Can I stop the change event being triggered?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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?

thanks

M
 
apologies - I misread the question. you could create a 'flag' to exit
control2's event

say bIgnore as boolean

in control1 set thios to TRUE, make the change, then set it back to false
in control2 make the first line
If bIgnore then Exit Sub
 
Check your other thread.
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?

thanks

M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top