Add new combobox to userfrom and assign an event which opens another new combobox

[gr3gor13]

My aim is as follows:

- When a combobox is selected (_enter) I want it to create a new combo box just under the combobox selected
- With this newly created combobox, if that is then selected (_enter) I then want to create another new comobox just below that one, and so on and so on until a maximum of five are created
- With each new combobox I want to assign a list from a sheet range

I am trying to use a class module to create further new comboboxes, however, I am getting very confused how to do this. I have seen similar examples that displays a message box when a combobox is selected and a message box is displayed.

Any help on this would be greatly appreciated.

[Norie]

Why not add 5 comboboxes at design time and hide 4 of them.

Then you can use code to show each combobox when required.

[gr3gor13]

This is what my original plan was, however i would like to get some experience using class modules and how to handle event changes.

Any example of to implement this would be really helpful.

[Norie]

You could use a class for the events of the 5 comboboxes added at design time.