Table of contents
TOC
Collapse the table of content
Expand the table of content

DropDown Method Example

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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
© 2018 Microsoft