Deconflicting Combobox Change Events

[Neuk]

The function combobox (CB_FUNC) determines what list the Component combobox (CB_COMP) generates. Therefore, the two are interdependent. Additionally, when the user selects an option from either one of these comboboxes a code generates in the search textbox (TB_SEARCH) . The lists, as well as the code generated, are based off the named range (GEN_CODES). While I got everything as I explained to work, I would like that whenever CB_FUNC and CB_COMP have values displayed, the BLN combobox (CB_BLN) and FLN combobox (CB_FLN) are null, which is where I am struggling.

The BLN combobox (CB_BLN) and the FLN combobox (CB_FLN) are NOT interdependent. When one has a value displayed the three remaining comboboxs should show a null string. For example, if a user selects an item from CB_BLN then CB_FUNC, CB_COMP, and CB_FLN should all show an empty value. Or if a user selects an item from CB_FLN then CB_FUNC, CB_COMP, and CB_BLN should all show an empty value.

PROBLEM: The change events for CB_FUNC, CB_COMP, CB_BLN, and CB_FLN appear to create an endless loop (when one changes the others change and this goes back and forth until excel ultimately crashes). I've tried enable events, I've tried various renditions of if, and, or clauses to narrow down exactly what I want to have happen, among many other things. I'm at my wits end. While everything else seems to work the way I explained, this is my one hold up. Your help would be greatly appreciated.

Note: to show the userform click on cell A11 on the “Points” ws. To see the named ranges go to the “Parts” ws. Thanks again for any help.

Please Login or Register  to view this content.

[1aaaaaaaaaaaaaaa]

Hi- please see attached

What I did was added a flag to check to see if the UI was updating before running the code to change the values in the combo boxes to null.

This way the first combo box change events prevents any other combo box change events from firing their code to null the other combo boxes and creating a infinite loop.

Once the first change event is finished the UI updating flag is set back to false.

See if this works for you

[Neuk]

Thanks Poizhan, that did the trick. I see you created your own window to isolate the change events from firing where then you inserted the code in question. That makes sense. Thanks for showing me.