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
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

Declaring Command Bar Control 4
Control1 GotFocus and Control5 RowSource 5
"tabbing" from one element to the other 3
Which form event would I use? 3
Pass a Function Value thru several Subs 1
Dock and Z-Order Problems 5
How to stop even processing? 1
ASP.NET1.1: Event sequence (Page vs. Control)? 1

Back
Top