Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a macro to return drop down boxes to first item i.
I am using Excel 2000 and have created serveral combo boxes using the forms
menu. I want to create a macro that returns each drop down box to the first item in the list of choices, or alternatively to an empty state. The combo boxes all appear on the same sheet and the lists of items and cell references are all on a different sheet. My familiarity with visual basic is very limited. |
#2
|
|||
|
|||
Option Explicit
Sub testme() Dim myDD As DropDown For Each myDD In ActiveSheet.DropDowns myDD.ListIndex = 0 ' or 1 Next myDD End Sub 0 clears the dropdown. 1 choses the first choice. gaalseth wrote: I am using Excel 2000 and have created serveral combo boxes using the forms menu. I want to create a macro that returns each drop down box to the first item in the list of choices, or alternatively to an empty state. The combo boxes all appear on the same sheet and the lists of items and cell references are all on a different sheet. My familiarity with visual basic is very limited. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
Dynamic Drop Down Boxes | Excel Worksheet Functions | |||
Macro to create macro | Excel Discussion (Misc queries) | |||
How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |