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