Combo Box wont Display list on initial launch

Hello,

I just made my first VBA and it's working good, though I have a couple of issues and i would really appreciate your help -

The first item on my userform is a combo box and the rest of the items will be activated depending on the option from that combo box that the user picked the code is:
Code:

Please Login or Register  to view this content.

The problem is when I launch the userform and I select the drop down, it does not give me the options but when i click the "Clear" button which is supposed to clear the values of the boxes if the user decided not to push through with what he entered it now gives me both values.

The code for the clear button is

Please Login or Register  to view this content.

Now, the funny thing is, when I click the Clear button it doubles my combo box options by adding the same list again. It repeats the same process everytime I click the Clear button.

I would really appreciate any thoughts on this.

thank you much!

Just to add, when I said it gives me the option when i hit the "clear" button after the initial launch, what it probably does is made the options available after the reset (call userform_initiate)

Hello,

Thanks for looking into this. Yes, it is in the Userform's code module. I am able to launch the userform, though on the initial launch, the options of the 1st combox (or all the combo boxes for this matter if I enable them) are not available unless i hit the "clear" button.

Hello,

I was able to make it work by putting the selection in the excel sheet rather than code module. thanks!