I have a few ActiveX comboboxes on a sheet. Each of them has a change event attached to it. However for one combo box change event, it triggers the rest of them to fire off which is unwanted. What should I do to prevent this? Should I set up a bolean variable to stop the rest to run? It's always confusing to me on how to turn it back on. Many thanks!
Private Sub cboBilling_Change()
sheet1.Range("rngbilling") = cboBilling
sub1
End Sub
Private Sub cboDivision_Change()
sheet1.Range("rngdivision") = cboDivision
sub1
End Sub
Bookmarks