Next, we will click on Developer to highlight and lastly tap the Add button.

If we can’t find the Developer in that column, we will go to Choose Commands from and select All Tabs.

In the column on the right, we will mark the checkbox for the Developer.

In the Excel Options dialog box, we will click on Customize Ribbon.

We will go to the File tab and select Options.

If we cannot find the Developer tab in the ribbon at the top of our spreadsheet, here is what we will do.

One of these options is called ActiveX Control while the other is Form Control.įigure 1 – How to use combobox Setting Up a Workbook to Create Combobox In this article, we will explore two easy ways to create a combobox in excel.

In the Project Explorer, double click on UserForm1.We use the Combo box, which is a drop-down list element to gain more control over the input of our user. Although it looks neat already, nothing will happen yet when we click the command buttons on the Userform.ġ0. We have now created the first part of the Userform. The last code line assigns the array to the combo box. Next, we declare and initialize a two-dimensional array.

To achieve this, right mouse click on the combo box control, click Properties and set the ColumnCount property to 2. Instead of setting the number of columns at runtime, you can also configure this setting at design time. To show the Userform, place a command button on your worksheet and add the following code line:Įxplanation: The first code line sets the number of columns of the combo box to 2. To change the caption of the Userform, label and command buttons, click View, Properties Window and click on each control.ĥ. It is good practice to change the names of the controls, but it is not necessary here because we only have a few controls in this example. Captions are those that appear on your screen. You can change the names and the captions of the controls. Next, you can drag a combo box on the Userform.Ĥ. For example, create a combo box control by clicking on ComboBox from the Toolbox. Once this has been completed, the result should be consistent with the picture of the Userform shown earlier. Add the label, combo box and command buttons. If the Toolbox does not appear automatically, click View, Toolbox. If the Project Explorer is not visible, click View, Project Explorer.Ģ. To create this Userform, execute the following steps.ġ.

Excel userform combo box two columns