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 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?