Assign Macros to a dropdown list
Not by assinging. In you single macro, you would use/examine the listindex
property and make a decision about which of the 14 macros to call.
--
Regards,
Tom Ogilvy
"JT" wrote in message
...
I have a dropdown list on an Excel sheet and would like to assign macros
to
each of the 14 entries that are in the drowdown menu. I am able to assign
a
single macro that runs when clicking on any name in the list but I want to
assign a different macro to each name in the list. Can that be done?
Thanks
|