CD,

Try Debra Dalgleish's great site

http://www.contextures.com/tiptech.html

scroll down to the "D" section and find listings for "Data Validation
which in one form or another is what you are looking for. Debra giv
multiple examples and even downloads of workbooks showing th
techniques. You won't be disappointed.

HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=55138