View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Blue Aardvark Blue Aardvark is offline
external usenet poster
 
Posts: 31
Default 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