Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox AddItem code to reference cells in a Range | Excel Discussion (Misc queries) | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
AddItem Method - Combobox value | Excel Programming | |||
additem to a combobox from other excel worksheet | Excel Programming | |||
Multiple Column ComboBox using Additem | Excel Programming |