Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link macro to change an item in drop-down list
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link macro to change an item in drop-down list
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 "Amotif" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select more than one item from a drop down pick list? | Excel Worksheet Functions | |||
drop down list/typing item from list error | Excel Worksheet Functions | |||
How do I set up a drop down list to beginning letter of item? | Excel Discussion (Misc queries) | |||
multiple item entries from drop-down list | Excel Discussion (Misc queries) | |||
Attaching a 2 item list to a cell / drop-down? | Excel Discussion (Misc queries) |