I am using Excel 2003 and that version will be used by everyone viewing the
file. I inserted the dropdown box into the sheet using the forms toolbar.
That is as far as I got except for using the assign macro menu to get a
single macro to function when clicking on any of the names in the dropdown
box.

"Tom Ogilvy" wrote:

Are you using a dropdown/combobox from the forms toolbar

Are you using a combobox from the control toolbox toolbar

Are you using the list option from Data=Validation (if so, what is the
earliest version of Excel that will need to load this workbook?)

--
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