combobox additem
 

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

combobox additem
 

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

With

--

HTH

RP

"masterphilch" wrote in message
...
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

combobox additem
 

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"

--

HTH

RP

"masterphilch" wrote in message
...
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