Multiple macros to one drop down

[bailey537]

is it possible to assign more than one macros to a single drop down menu. What i have is a drop down menu that gets it's range from a list. I want to run a macro to update its range when i click on the down arrow and also have another macro run when i select one of the options. I have done the macros themselves i just need to know how to apply them to each situation

 

[Andrew Poulsom]

A ComboBox from the Control Toolbox has a Change event and a DropButtonClick event. You may find that one causes the other to fire, in which case you will need to include event disabling in your code.