DropDown Method

Applies To

ComboBox control.

Description

Displays the list portion of a ComboBox.

Syntax

object.DropDown

The DropDown method syntax has these parts:

Part	Description

object	Required. A valid object.

Remarks

Use the DropDown method to open the list in a combo box.

See Also

DropButtonClick event, DropButtonStyle property, ShowDropButtonWhen property.

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