Problem in creating combobox by clicking button in UserForm

[excalaibur]

Hi,

I created a UserForm in Excel which originally has 1 combobox. I want the UserForm to add new combobox right below the last combobox in the lowest position. The macro works but it skip the second combobox.

Please Login or Register  to view this content.

And it what happens when I click the button "Add Site"

???? 2017-08-27 ??10.42.25.png

I cannot figure out where is this error come from. Is here anyone can help.

Thanks in Advance.

[mehmetcik]

You have two errors. Highlighted in Red. You do not need +1

Please Login or Register  to view this content.

I must say would it not be easier to create all the ten comboboxes and make nine of them invisible, rather then adding them using the macro?

I would assume you have to create the code to drive them up front anyway.

[excalaibur]

You have two errors. Highlighted in Red. You do not need +1

Please Login or Register  to view this content.

I must say would it not be easier to create all the ten comboboxes and make nine of them invisible, rather then adding them using the macro?

I would assume you have to create the code to drive them up front anyway.

Thank you so much mehmetcik.

I had found some post here teaching how to create invisible combobox.
Since I want to use the number of combobox created to set the variable in another macro in Module. So I try to code the userform to be able to create new combobox.