See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"pcor" wrote in message
...
A long time ago I had some code to add a drop down menu to Excel. Can some
kind soul please direct me to a location where I can recapture that
code.\Thanks