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!