Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Boxes Interaction Infinit Loop

Status
Not open for further replies.

sabascal

IS-IT--Management
Aug 20, 2002
85
GB
Here is the problem I am having.
-I have 2 ComboBoxes: Combo1 and Combo2 with 2 associated Combo#_Change() procedure
- Combo1 is linked to cell A1
- Combo2 is linked to cell A2

My 2 Combo#_Change()are updating the sheet including A#
As a result I have an infinite loop.
When I call Combo1_Change() it updates A2, which calls Combo2_Change()....

How can I solve this?
 
I haven't used this in a while, but try including the line

application.enableevents = false

at the start of your combo#_change() procedure. This should then allow you to make whatever changes your code needs without triggering the other change events. Remember to put

application.enableevents = true

at the end of yuour procedure though!
 
Thanks murad5 but I tried already an it has no effect.
Anything Else?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top