software

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

stumakker, have a look here and see if this will work for you,

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 amp; 2003

quot;stumakkerquot; gt; wrote in message
...
gt;I have a cell containing a drop down box with three options. Can i design
gt;my
gt; worksheet so that when one option is selected a drop down box in the
gt; neighbouring cell appears with a number of options in it?
gt;
gt; Each of the original 3 options in the first drop down box needs to lead to
gt; a
gt; different list in the second drop down box, though the options can be
gt; repeated.
gt;
gt; Any help would be much appreciated.
gt;
gt; Thanks
brilliant!!

thanks for the help

quot;Paul Bquot; wrote:

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