Populate and use ComboBoxes like filters

[chowee21]

Alright, this one should be a good one and hope someone can help me out there....

animals.jpg

See the above picture...

I want a way to be able to populate the data on the left into the comboBoxes in a userform on the right.

Here's the fun part... I want to then use the comboBoxes to "filter" the selection. So when the I change the 'Animal', the 'Color' and 'Adult', it will filter and will only show unique values that are left. (i.e. if black is listed 4 times, it will only show it once).

The form will function like filter, but will be more user friendly.

I will then return the ID number of the configurated animal to cell F2. (i was going to use concatenate and a vlookup to do this in excel... so that's not the important one issue)

[chowee21]

Hmmmmm anyone?

[jwalma]

You could use vlookup in a formula set up in vba there are several examples on youtube on how this works.

The best one is by Family Computer if I remember correctly.