Can I stop the change event being triggered?

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
 
J

Jan Karel Pieterse

P

Patrick Molloy

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
 
D

Dave Peterson

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
Click to expand...
 

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

Similar Threads

event that cannot be disabled? 6
Control1 GotFocus and Control5 RowSource 5
Declaring Command Bar Control 4
Worksheet Activate event not firing 4
Pass a Function Value thru several Subs 1
application.EnableEvents = false not disabling events 6
Combo box change event triggered from another file 0
Why is this Worksheet Change Event triggered? 7

Top