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

--
---
HTH

Bob


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



"IGG" wrote in message
...
I'm hoping you can help;

I'm trying to create a function I have seen on other worksheets; basically
when a cell in clicked on, a small drop down menu will appear to the right
hand side with pre-determined text of the aurthers choice. e.g. if I had a
column into which I would only ever need to type three possible data
choices
i.e. "Yes", "No", "Maybe", it would allow me to scroll down and select the
one of my choice. Hope you can help. Many thanks.