Hi
You will find some easy to follow instructions for using Data Validation
to achieve this on Debra Dalgleish's site
http://www.contextures.com/xlDataVal01.html
Debra also shows examples of how to use the Combo box as well.
--
Regards
Roger Govier
"SMGray" wrote in message
...
Help! I would love to use a drop down field in my spreadsheet without
having
the data located on a separate sheet....I assume that the Combo Box
and or
List Box would do the trick....But I ABSOLUTELY can not figure out how
to use
them....CAN ANYONE HELP!?!? PLEASE!