View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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