Linked Textbox Controls on Form - Avoiding Cascading Change Events
Hello
I have 3 textboxes on a form. I want to allow the user to change one of them
and for the other 2 to automatically update. My code looks something like
this:
Box1_Change
Box2.value = ........
Box3.value = ........
end
However, when I set the values on the other boxes I start their Change
methods and I end up in an infinite loop. I have tried an
"Application.EnableEvents = False" to avoid this but it didn't work. Any
ideas on how to avoid this situation?
Thanks,
Steve
|