Combo BOX

[lidapa]

Hello my friends
I am trying to use a combo box in my userform but it doesnt seem to work.
The code I am using to start the form is the following

sub x()
UserForm1.Show
end sub

Also have

Private Sub userform1_initialize()
Combobox1.AddItem "Option1"
Combobox1.AddItem "option2"
End sub

But my Combo box doesnt show anything
Seems like my sub INITIALIZE is not working
Thanks

 

[pedie]

change UserForm1 to UserForm

[/FONT]
[FONT=Courier New] [/FONT]
[FONT=Courier New]Private Sub UserForm_Initialize()
 Me.ComboBox1.AddItem "TEXT"
End Sub
[/FONT]
[FONT=Courier New]

 

[lidapa]

You are star Pedie
It is working now

 

[pedie]

You are star Pedie

It is working now

Star is over Rated but thank you...

You dont actually write
Private Sub UserForm_Initialize()
you just need to select form from the editor and it will give you the correct syntax...