DropDown Method Example

The following example uses the DropDown method to display the list in a ComboBox. The user can display the list of a ComboBox by clicking the CommandButton.

To use this example, copy this sample code to the Declarations portion of a form. Make sure that the form contains:

• A ComboBox named ComboBox1.
• A CommandButton named CommandButton1.

Private Sub CommandButton1_Click() ComboBox1.DropDown End Sub Private Sub UserForm_Initialize() ComboBox1.AddItem "Turkey" ComboBox1.AddItem "Chicken" ComboBox1.AddItem "Duck" ComboBox1.AddItem "Goose" ComboBox1.AddItem "Grouse" End Sub