Are you referring to assigning a number of macros to one cell & then select from the Drop down list? This is a bit complicated & will require additional VB codes referencing to that cell.
I am assuming you have written a number of macros & now want to assign the macros to various cells. For Excel 2007 … the simplest way will be:
1) Click on your designated cell, Then click on the Tab Insert & then click Shapes. Select the first cell Under Callout.
2) Now click on the designated cell. The Callout structure will appear. You can size it by dragging the “Handles”. Type the macro name or other info on the CallOut space.
3)Now right click on the cell & select Assign Macro. Select the Macro you want to associate with this cell.
4)Move away from the cell & then click again on the cell.
5)Your assigned macro should execute.