How to link macro to change an item in drop-down list

A

Amotif

As part of a small macro I am writing, I want the macro to change (or pick
up) an item from drop-down list in a combo box. On completion, the macro
functions on all areas except changing the item on the drop-down list.
 
J

Joel

Use Listindex which starts at zero for the first item

ActiveSheet.ComboBox1.ListIndex = 6

for i = 0 to (ActiveSheet.ComboBox1.Listcount - 1)
ActiveSheet.ComboBox1.ListIndex = i
next i
 

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

Running a macro when selecting an item in a drop-down list 4
ADD ITEM TO A DROP DOWN LIST? 4
Use word to associate an item in validation drop down list 2
Excel, Macro, Drop down list 15
Drop down list and macros? 1
Filtered drop down list 2
Create Drop Down Box populated by a List 1
Position of a drop-down list 5

Top