how to assign a different macro to each*combobox selection in form control....

Hi Everyone,

I am very new to macros...Trying to assign a macro to a form control combo box. I've looked up information online, but I still cannot seem to get this to work.

I inserted the combo box via Developer > Insert > Form Controls. Then I went to Format Control and selected the items via Input Range.


I've tried selecting the*combobox*and assigning the macro but this only assigns one macro to the whole*combobox. So only the macro assigned runs no matter which item is selected in the*combobox.

I have 7 different items to select from from the combo box. When each is selected, I want a different macro to run.
and also i have recorded all 7 macros.

But i dont knw how do I assign a different macro to each*combobox selection?

Please help me all...