Starting points:

1. It is known that a macro can be assigned to a shape - Create shape, "Assign Macro..." I've managed to create single shapes assigned to single macros that run macro when clicked.

2. Figured out how to create a drop-down list of items, and run single macro tied to item selected from drop-down list. Thanks Forum!

The question: Is there a way to combine the two? My goal is to have a plain shape/button that says something like "Select Item". When the user clicks on the button, the drop down list appears (Item1, Item2, etc.), with a single selection made, and single macro (Item1Macro, Item2Macro, etc.) tied to selection runs.

Would this need to be done with a Command Button (ActiveX Control)? Still learning VBA, haven't gotten that far yet...