Userform Combo Box Not Initializing

[Larmonely]

I have simplified my problem and put it in the attached file. The problem is, when I click a button that calls userform.show, the combobox is not initialized. I am unsure as of how the method initialize is even called, although I am fairly sure it is supposed to be in the userform code. I've searched online for quite a while on this subject, and I have also referred to several guides on using userforms, but none of them have solved my problem.

I have put in

Please Login or Register  to view this content.

in my Sheet1 code.

My Userform1 code looks like this:

Please Login or Register  to view this content.

Any thoughts or advice would be greatly appreciated.

Userform 2012 07 18 at 1456 Luo.xlsm

[StevenM]

How about?

Please Login or Register  to view this content.

[Larmonely]

Did it work for you? It's not working on my computer, and if it did on yours, something must be funny with my settings.

The code for Userform1 is now

Please Login or Register  to view this content.

But it still appears as

error.png

[StevenM]

See how the "u" in Userform1" and the "i" in "Initialize" is not capitalized?

Try using the drop down menus (at the top of the module) to create Private Sub userform1_initialize()

Using the left side, click on userform1 and then, using the right side, click on initialize. It should create for you:

Please Login or Register  to view this content.

Then cut and paste:

Please Login or Register  to view this content.

So that you end up with:

Please Login or Register  to view this content.

That should solve your problem.

[Larmonely]

Thank you SO much! I had no idea that you had to select "Initialize" from the combobox. None of the guides I read explicitly said that, so I just wrote it myself. It's strange though, that you need to do that, because I right clicked my userform to get to its code, and one would think that would be enough. Nonetheless, thank you very much!