Hi
see:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany
"UisNike" schrieb im Newsbeitrag
...
I am looking to set up validation lists with data in a large excel
spreadsheet so that people can only type the values that I choose. I
would
although like them to be able to choose the choices that i offer from a
drop
down menu so all information is consistent. Each cell that I would like
validated should have a little drop down arrow at the right. Any ideas on
how
to do this??