Assign Multiple macros to an Active X Combobox

[sanjessky]

I'm having difficulty assigning multiple macros to an active x combo box. I want a different macro to run every time the user selects a different product from the combo box. I can assign one macro to the button no problem, but don't know how to incorporate more. My macros are Chevrolet1 and Toyota2 so far. I will be adding more once I figure this out. So far the list in my combo box is Chevrolet and Toyota. Again, I will be adding more once I figure this out. My first sheet in my workbook is called Sheet 1. Basically once the user selects say Chevrolet from the combobox, the Chevrolet1 macro would run and populate that information in specified cells. Any help is much appreciated. Thank you!

 

[Michael M]

You can't really assign multiple macros to one combo box....Try having a look at the Select Case method in one macro
Select Case will allow the Case statement to do the necessary actions depending on the value selected by the user !