Populate and use ComboBoxes like filters

[chowee21]

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

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)

So for example... if i choose "Dog" under "Animal"... when i click on the "Color" drop box, i should only see "Black", "Yellow" and "White" since yellow is not a dog color.

 

[chowee21]

Not 100% sure.. leave the ComboBox7 code as it is now (with change i sent in previous post).. and try putting code liek this for all the other combos..

For Each it In Range("B1:B" & Range("B" & Rows.Count).End(xlUp).Row).Offset(1).Resize(Range("B" & Rows.Count).End(xlUp).Row - 1, 1).SpecialCells(12)

It offsets it down 1 row and then resizes it to the row count -1 so that you don't get blanks in your combos..

Like i say.. not 100% sure.. see how you go..

U da man, thanks for the help!