View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Daniel Jones Daniel Jones is offline
external usenet poster
 
Posts: 18
Default Add Item To ActiveX ComboBox

Thanks! How would I go about deleting all of the items in the
combobox? I could only discover how to delete one at a time like so

Worksheets("Sheet1").ComboBox1.RemoveItem (0)

On Aug 27, 5:18*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Sheets("Sheet1").ComboBox1.AddItem ("Item1")
--
HTH...

Jim Thomlinson

"Daniel Jones" wrote:
I want to add an item to an activeX combobox that is located on a
worksheet. *Note this is not the combbox from the forms toolbar, and
its not the combobox inside of userforms, its the control toolbox
combobox.


I'm getting an object doesn't support this property error when I try
the following:




Sub PopulateList()
Worksheets("Sheet1").ComboBox1.Items.Add ("Item1")
End Sub


How do I add an item to this combobox? *I don't want to use the
ListFillRange property b/c I will be putting this inside of a loop.


Thanks in advance!