Combo Boxes Interaction Infinit Loop

[sabascal]

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?

 

[murad5]

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!

 

[sabascal]

Thanks murad5 but I tried already an it has no effect.
Anything Else?