How to Stop Active X Combo Box Firing when list source changes

[LahnyKate]

Hello All,

First time posting. I am only a beginner with VBA.

I have a number of active x combo boxes and they are firing the vba when the list source changes.

Can anyone help on how to stop this happening?

This is what I currently have to try and stop but is not working. When you click on the combo box and select an option out of drop down list, this is the only time I want this to fire, unless being called from another macro.


Private Sub ComboBxCustomerID_Click()

bmakeithappen = True
Call ComboBxCustomerID_Change

End Sub


Private Sub ComboBxCustomerID_Change()


If bmakeithappen = False Then Exit Sub

Application.ScreenUpdating = False 'Turn Screen Updating Off

 

[Fluff]

Hi & welcome to the board.
Why not put all the code from the Change Event into the Click Event and get rid of the Change Event