Use data validation (List option) and the change event if you are using
xl2000 or later.

--
Regards,
Tom Ogilvy

"arizona302 " wrote in message
...
I can't figure out how to assign macros to text or how to create a drop
down box with each choice linked to a macro? Does this make sense - -
can I do this? Help!! Thanks.


---
Message posted from http://www.ExcelForum.com/