UserForm listbox won't initialize

[korhan]

Hello Mr.Excel Community,

I have a really simple question which I couldn't figure out by myself.
My listbox won't initialize no matter what I have tried. I have tried to initialize the listbox when I open the form, I have also tried a click event and none of them worked.

Here is my test code for Form Initialization
Sub QuoteForm_Initialize()
' Fill the list box
Me.lstItemNames.AddItem "Orange"
End Sub

And test code for ListBox click event:
Private Sub lstItemNames_Click()
Me.lstItemNames.AddItem "Orange"
End Sub

 

[RoryA]

This line:

Sub QuoteForm_Initialize()

should be:

Sub UserForm_Initialize()

You don't change it to match the name of the form.

 

[Rick Rothstein]

This line:

Sub QuoteForm_Initialize()

should be:

Sub UserForm_Initialize()

You don't change it to match the name of the form.

To follow up on Rory's comment... you should never type an event header out yourself... always click the left-hand drop down above the code type-in area and select the object from there, then select the event header itself from the right-hand drop down and let VB supply the correct event procedure header for the object for you.

 

[korhan]

Thank you so much for the answers. I thought that the behavior would be the same as in VB.
I guess there are some fundamental differences between VB and VBA.
Thank you all.