Menu

Navigation

How do I create a ComboBox in Excel VBA?

Posted on by Arif Clayton

How do I create a ComboBox in Excel VBA?

VBA ComboBox_Control on the UserForm

  1. Go To Developer Tab and then click Visual Basic from the Code or Press Alt+F11.
  2. Go To Insert Menu, Click UserForm.
  3. Drag a ComboBox on the Userform from the Toolbox.
  4. Double Click on the UserForm, and select the Userform event as shown in the below screen shot.

What is a combo box in Excel VBA?

A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA, execute the following steps.

How do you populate a ComboBox in VBA UserForm?

To populate a combo box on a userform in Excel you need to use VBA. Firstly add a combo box to a userform in the VBA window (Alt-F11) of your spreadsheet. The VBA code below shows how to populate a 2 column combo box. Add this code to the Userform Initialize event to populate the combo box when the form is loaded.

How do I activate a ComboBox in Excel?

To add or edit the Combobox, follow these steps:

  1. On the Ribbon, click the Developer tab.
  2. Click the Design Mode command.
  3. Click Insert, and under ActiveX Controls, click on the Combo box button, to activate that tool.
  4. Click on an empty area of the worksheet, to add a combo box.

How do I create a ComboBox in Excel?

Add a combo box to a worksheet

  1. Pick a column that you can hide on the worksheet and create a list by typing one value per cell.
  2. Click Developer > Insert.
  3. Pick the type of combo box you want to add:
  4. Click the cell where you want to add the combo box and drag to draw it.

How do you use a combo box?

How do I add items to a ComboBox in Excel VBA?

Go to the VBA window (Alt + F11) > double-click the UserForm from the Project window (Ctrl + R if it’s not visible) and then, once the form is visible, click the ComboBox that you want to fill with values. Look to the Properties window and scroll down to RowSource. If the Property window isn’t visible, hit F4.

How do I fill data in a ComboBox in Excel?

Add a list box to a worksheet

  1. Create a list of items that you want to displayed in your list box like in this picture.
  2. Click Developer > Insert.
  3. Under Form Controls, click List box (Form Control).
  4. Click the cell where you want to create the list box.
  5. Click Properties > Control and set the required properties: