User Form Dependent Dropdown (ComboBox)

Hi All,

I currently have a userform with two different drop downs where I'm looking to have one of the drop downs (called subtype) be dependent on whats chosen from the other drop down (Called Type).

I have about 10 named list (list1, list2, list3...) in which i will likely need a substitution function to remove the spaces from what's picked in the "Type" combobox (list 1, list 2, list 3...).

Not sure if it's possible in VBA, but through data validation a subsitution/indirect function would be how I'd do it =INDIRECT(SUBSTITUTE(Type," ",""))..


Thanks in advance!

Thanks for the response. This is correct, I have about 10 "primary type", with each type generating a list of about 40 or so "subtypes". Is it possible to identify the named range? So for instance:

If ComboBox1.text = "TypeA" Then ComboBox2.Value = Range("Your range")

Can "Your range" be pulled from the "lists" tab with the "TypeA" named range?