ActiveX ComboBox Control on Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove all items from an ActiveX control on a sheet 4
Combobox filtering 2
Add Item To ActiveX ComboBox 17
postion of dropdown list with sheet combobox 1
Userform combobox: best match on partially typed content? 4
How to copy ActiveX Controls which are locked on a sheet 1
Iterating through a ComboBox's values 6
ActiveX Control Combo Box 9

Back
Top