combobox in a userform?

[ksmith]

how do i populate a combobox in a userform? the options are different when the combobox is in a userform...???

thanks!

 

[zacemmel]

ComboBox1.additem "youritem"

 

[ksmith]

i still can't get it to work----is this code put in after combobox1_change() or somewhere else?

thanks!

 

[rg]

You can put the code in the 'Userform_Initialize()' event.
remember to substitute the correct name of your userform(eg. "Myuserform" etc.) for the word "Userform" shown above.
eg.
Private Sub Myuserform_Initialize()
.AddItem "the name you want to add"
.AddItem "the next name etc"
End Sub

Hope this helps

 

[ksmith]

Thanks!