Use Select/Case

Sub Macro()

Select Case Range("B1")
Case "a"
Run "macro1"
Case "b"
Run "macro2"
Case "c"
Run "macro3"
End Select

End Sub

If this post helps click Yes
---------------
Jacob Skaria


"KG Old Wolf" wrote:

I want to assign multiple macros to a toolbar "button" and execute the right
macro based on a DropDown list's selection: ie-

Press "button"
examine value from dropdown list
choose the correct macro
execute
-----------------------------------------
I have the (4) macros written and working (via recorder) and could assign
them to separate "buttons" but I know there is a more professional way to do
this...

Thanks,
KG-