Automatically create Combobox

[orcas]

Hello there,

Thanks for looking in.

I am looking for a solution to a ComboBox issue. What i will like to do is to automatically create comboboxes based on the value selected by the user from an initial combobox.

For example, if the user selects a value of 3, i will like the form to automatically create 3 different comboboxes.

I have attached the excel file I am working with and any help from you will be tremendously appreciated.

Cheers

[SamT]

You would be better off creating the three boxes at design time, setting their visible properties to false and using the selection from the initial box to reset the visible properties of the three.

If you create the boxes at run time, your next question for us will be "How do I set a ComboBox property with VBA?" :whistle: