Using an IF/THEN from across 2 drop down (combo) boxes???

[Jim Sharky]

....hope I do an adequate job explaining myself here.

I have a spreadsheet with multiple drop down boxes.

The question is this: Is it possible to have one drop down boxes selections
be contingent upon what was chosen in the previous drop down?

For example, the available selections for drop down box #1 are A, B, and C

IF user selects A from drop down box #1, then drop down box #2 has
selections of Red, White, and Blue
IF user selects B from drop down box #1, then drop down box #2 has
selections of Green, Yellow, Black
IF user selects C from drop down box #1, then drop down box #2 has
selections of Orange, Brown, Purple

Haven't quite figured out whether this can be done within the context of
combo boxes.

Any help would be great.

Thanks.

Jim

 

[RagDyeR]

Check out this page from Debra Dalgleish's web site:

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

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

....hope I do an adequate job explaining myself here.

I have a spreadsheet with multiple drop down boxes.

The question is this: Is it possible to have one drop down boxes selections
be contingent upon what was chosen in the previous drop down?

For example, the available selections for drop down box #1 are A, B, and C

IF user selects A from drop down box #1, then drop down box #2 has
selections of Red, White, and Blue
IF user selects B from drop down box #1, then drop down box #2 has
selections of Green, Yellow, Black
IF user selects C from drop down box #1, then drop down box #2 has
selections of Orange, Brown, Purple

Haven't quite figured out whether this can be done within the context of
combo boxes.

Any help would be great.

Thanks.

Jim