Linked Combo Boxes

Is it possible to link two combo boxes so that your selection in the first
box limits the amount of information you have available in the second box?

Okay, this isn't very elegant, but it worked.

I did four columns...A-D...don't ask why I skipped C
A B C D
Colors Things 3
Purple =IF($D$1=3,"Grass","") 1
Blue =IF($D$1=3,"Eggs","")
Green =IF($D$1=2,"Sky","")
=IF($D$1=2,"Moon","")
=IF($D$1=1,"Rain","")
=IF($D$1=1,"People","")

I created a combo box on the data in A. The resut is in D1. Depending on the value of D1, certain items will appear in column B.

I then created a combo box for column B with the value in D2.

Problem - You get a lot of blank spaces in the second combo box. Workaround for that problem? I created a macro to sort Column B in descending order. I set the First Combo box to run that macro every time the combo box changes. I then changed the Second Comob box to use on B2:B3. It works...but you will want to merge D1 and D2 together to get a "for sure" value of what the final result is.

Not elegant...but it will get the job done.

Bleck...not familar with this forum I guess. Not sure why but it gets rid of all of my extra spaces in my "sample data". As such, here is what it should look like...

Column A has the three colors with the title Colors
Column B has the title Things with all of the formulas
Column C was empty
Column D has the 3 and 1 in it

Thanks Lotus123...
I'll give it a try.

"Lotus123" wrote:

>
> Bleck...not familar with this forum I guess. Not sure why but it gets
> rid of all of my extra spaces in my "sample data". As such, here is
> what it should look like...
>
> Column A has the three colors with the title Colors
> Column B has the title Things with all of the formulas
> Column C was empty
> Column D has the 3 and 1 in it
>
>
> --
> Lotus123
> ------------------------------------------------------------------------
> Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
> View this thread: http://www.excelforum.com/showthread...hreadid=484165
>
>