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

  • Thread starter Thread starter Jim Sharky
  • Start date Start date
J

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
 
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
 
Back
Top