Hi,

using the Excel form controls is it possible to filter one combobox based on another one?

So combo1 sourced from C1:C3
item1
item2
item3

Combo2 sourced from E1:F6
Col1 , Col2
item1, subitem1
item1, subitem2
item2, subitem3
item2, subitem4
item3, subitem5
item3, subitem6

What i want is combo2 to only display the values in Col2 were Col1 equals the value in combo1

Found the solution to my problem here:

http://www.contextures.com/xlDataVal02.html

I was looking for something complicated and it turned out to be something simple.