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

....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!
=====================================================

"Jim Sharky" <sharkyjim@aol.com> wrote in message
news:11k2g9afa4bpg1b@corp.supernews.com...
....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