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
elseif combobox1.value= "NextCBoxSelectionHere" Then

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...