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

Thanks for responding Tom. I have no idea what you are suggesting. I
attempted to find the "examine the listindex property" that you suggested but
did not see it. I am new to this type of programming in Excel/Visual Basic so
I forgive my being slow.
Thanks

"Tom Ogilvy" wrote:

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