stumakker, have a look here and see if this will work for you,
http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"stumakker" wrote in message
...
I have a cell containing a drop down box with three options. Can i design
my
worksheet so that when one option is selected a drop down box in the
neighbouring cell appears with a number of options in it?
Each of the original 3 options in the first drop down box needs to lead to
a
different list in the second drop down box, though the options can be
repeated.
Any help would be much appreciated.
Thanks