ActiveX ComboBox Control on Sheet
 

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.

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.

ActiveX ComboBox Control on Sheet
 

Thanks Ron!

"Ron de Bruin" wrote:

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.