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.

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.

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.