Add Combobox to existing userform

[ttd]

Hi all,

I have an excel workbook that I've added a form named UserForm1. Instead of manually adding Combo boxes to this form via the Toolbox in Visual Basics I would like to add by runing lines of code in a macro or function. How can this be done?

The reason for this... The number of Combo boxes required for my report will change depending on variables derived from data housed in the worksheet when I run a macro. The macro may say add two combo boxes this time and 3 or 4 combo boxes the next time.

I really just need the simple code of adding a combo box to an existing userform. Thank you

[coreytroy]

Is there a maximum number of ComboBoxes required?
If so have you thought of simply setting the not required ComboBoxes to .Visible=False.
This way the code will always be available for each ComboBox also, and would make any ComboBoxes that are not required to be selected (Data dependant) are not visible.
Alternately you could use the .Enabled=False in a similar way also.