Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Events on controls generated on the fly... | Excel Programming | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Change events and linked cells | Excel Programming | |||
Add Controls With Events at Runtime | Excel Programming | |||
Events for Controls in a Multipage Control | Excel Programming |