combobox additem

[masterphilch]

Hi

I created a userform with a combobox. Now, I wanna add items to the
combobox, but there appears nothing. How can I add items from a
non-private procedure?

greez

 

[Bob Phillips]

Not sure what you mean by a non-private procedure, but you add items like so

With

 

[Bob Phillips]

Try again.

Not sure what you mean by a non-private procedure, but you add items like so

With Me.cmbTest
.Additem "Bob"
.Additem "Bill"
'etc
End With

You can also link it to a worksheet with

Me.cmbTest.RowSource = "$A$1:$A$10"