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.

Hi quartz

Me.ComboBox1.ListFillRange = ""

And

Me.ComboBox1.ListIndex = 4
It start with 0

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



"quartz" <[email protected]> wrote in message news:[email protected]...
>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" <[email protected]> wrote in message news:[email protected]...
> >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.
>
>
>