How to simplify Multiple ComboBox Change Event code

You can create a combobox class, or if not familiar with classes, create a "sub sAllComboBoxes_Change" with your required code, then each combobox should have it's own change event with 1 line that calls "sAllComboBoxes_Change"

Sure, there's plenty of examples for class events online, one of which simple to follow is http://www.ozgrid.com/forum/showthread.php?t=154659.

Regarding dependencies, if your comboboxes are all named "ComboBox" plus numbered and in the same sequence they are dependent (eg when combobox1 is populated open combobox2....etc) then your code can be kept generic relatively simple (untested example is for another generic sub in the userform module and is not using the class method):

Standard ComboBox Event:

Please Login or Register  to view this content.

Untested generic sub in the UserForm module (change to suit etc):

Please Login or Register  to view this content.

The above can be slimmed down further, but is hopefully easier to understand?

See attached, in Excel 2010. Hope this helps