drop down box leading to another drop down box

[stumakker]

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

[Paul B]

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" <[email protected]> wrote in message
news:[email protected]...
>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]

brilliant!!

thanks for the help

"Paul B" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>