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