Thread: ActiveX ComboBox Control on Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default ActiveX ComboBox Control on Sheet
Hi quartz

Me.ComboBox1.ListFillRange = ""

And

Me.ComboBox1.ListIndex = 4
It start with 0

--
Regards Ron de Bruin
http://www.rondebruin.nl



"quartz" wrote in message ...
I have an ActiveX combobox control on a sheet (the ole type). The box is
populated with a list.

1. How do you programmatically remove all items from the list (is there not
some equivalent to "RemoveAllItems")?

2. How can I programmatically set a particular entry to appear in the box
window (for example the fifth entry)?

Thanks much in advance for your assistance.


Reply With QuoteReply With Quote