Liz,

I'm pretty sure you can't do that. The only thing that comes to mind is to make your own
userform, with which you need to write macros to handle everything. A button on the
worksheet, similar to the dropdown button, would initiate your userform. It wouldn't appear
directly below the cell without some coaxing, though.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Liz" wrote in message
...
I have created drop down boxes in Excel using the validation tool but I need
each option to have a different fill colour. How do I do this?