ComboBox selection activate sub

Hi,

When the user makes a choice (selection) in the combobox he should activate a sub depending on his choice. How can I do this ?

Please Login or Register  to view this content.

There is Application.Run -

Please Login or Register  to view this content.

Hello Matrixknow,

A Control Toolbox ComboBox can have multiple columns. The macro to be run can be inserted in a column next to the item that will be displayed. When a choice is made, the adjacent column's string (the macro name) is pulled and executed.

Macro to Load ComboBox:
Change the Items and Macros to what you need.

Please Login or Register  to view this content.

ComboBox1 Code:

Please Login or Register  to view this content.

Sincerely,
Leith Ross