Dependent Drop Downs in UserForms

[cardinalphin]

I'm trying to create a userform with dependent drop-down lists in it. I'm trying to populate these lists from various tables that I've got saved in a couple of sheets. I know how to use dependent drop-downs within the spreadsheet, but I can't find anything on how to do it within a userform.

The closest solution I've come up with is to populate all of these drop downs by hard coding the options into VBA. I've got almost 100 tables, and I will eventually have considerably more, so hard coding isn't really a good, manageable option.

I'm able to populate the parent list in the userform, using the tables, but I've come up empty in my search for a solution to linking to the child tables, within a userform. My apologies if this has been covered elsewhere, but I can't find anything that matches what I'm looking for.

I appreciate any help you can provide, and hope you have a great turkey day!

 

[Norie]

How are the tables linked?

 

[cardinalphin]

I'm not sure if this is what exactly you're asking, but I named the tables per the names from the parent tables. IE, I've got a table named machines, which contains several values, one of which is CTM. I've got another table named CTM. I can use data validation, and the indirect function to perform this in the spreadsheet, but that's not, at least from what I can tell, an option from within the userform.

Hopefully that's the information you were after. I haven't done anything else to link them together.

Thanks for your reply!

 

[Norie]

So if the user was to select CTM from the parent combobox the child combobox would be populated with data from the table CTM?

 

[cardinalphin]

Correct. It seems to work pretty effortlessly using indirect and data validation...

Here's what I use in data validation to get to populate the child drop down list.

=INDIRECT($C$7)

Here's what I use to populate the parent list.

=INDIRECT("Components[Components]")

 

[cardinalphin]

The code above works great in the spreadsheet - just not so much within a userform.

 

[Norie]

You could use something like this.

ComboBox2.List = Range(ComboBox1.Value).Value

 

[cardinalphin]

You're awesome. That works perfect... Thanks so much!