MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking list/combo box selections to macros


Posted by Geoff CE on August 01, 2001 5:39 AM

How could I link different choices from
a list or combo box to a different macros,
as if I had a list of buttons?


Posted by Cory on August 01, 2001 7:49 AM

Try the ComboBox_Change and use some code like this:

If combobo1.value = "YourCBoxSelectionHere" Then
Macro1
elseif combobox1.value= "NextCBoxSelectionHere" Then
Macro2
elseif.....

End if

Change the stuff in "" to whatever the selections are in your combobox and change the Macro1, Macro2 to the names of your macros...

See if that works...

Cory