FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Combo Box in Excel

Updated on December 27, 2023
Article byHarsh Katara
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What is a Combo Box in Excel?

A combo box in Excel is a data validation tool that can create a drop-down list for the user to select from the predetermined list. A “Form Control” is available in the “Insert” tab of the “Developer” tab. In simple words, it is a list box where we can put a different list of values for selection. Whereas the VBA combo box is designed in a user form where we put our values in a list in Excel, the VBA combo box has the same functionality.

Types

  1. Form Controls Combo BoxForm Controls Combo BoxExcel Form Controls are objects which can be inserted at any place in the worksheet to work with data and handle the data as specified. These controls are compatible with excel and can create a drop-down list in excel, list boxes, spinners, checkboxes, scroll bars.read more
  2. Active X Controls

#1 How to Create Form Controls Combo Box in Excel?

You can download this Combo Box Excel Template here – Combo Box Excel Template

Below are the steps to create form controls combo box in Excel:

  1. We have created a “Month List” in the worksheet.


    Combo in Excel - step 5

  2. First, we must click on Developer Tab > Insert > Combo Box > Form Controls.


    Combo in Excel - step 6

  3. Then, we must select the “Combo Box” to draw in the worksheet.


    Combo in Excel - step 7

  4. Now, right-click on the combo box and go to “Format Control.”


    Combo in Excel - step 8

  5. As a result, the “Format Control” dialog box opens up. Under the “Control” option, make the following changes.


    Input Range: Range of cells that contain values that will appear in our combo box.

    Cell link: Put the cell’s address where the number of values from the list will appear. It can help us create the functions of charts based on the combo box.

    Drop Down Lines: Number of lines in combo box – it should be the number of values in a list or less.

    Combo in Excel - step 9

  6. Now, our combo box is ready.


    Combo in Excel - step 10

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#2 How to Create an Active X Controls Combo Box in Excel?

This kind of Combo Box is used in VBA CodingVBA CodingVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more. It is an advanced level of the combo box. So we need a bit of VBA knowledge. Anyway, let us go ahead and learn about this type of combo box.

To add the ActiveX Control combo box, follow the below steps.

click Developer Tab > Insert > Combo Box > Active X Controls
  • Step 2: Then, we must draw the combo box on the worksheet.
Draw the Combo Box
  • Step 3: Next, we must right-click on the combo box and select “Properties.”
Right-click on the combo box and select properties
  • Step 4: In this properties window, we can see all the properties associated with this combo box. We can change the name, size, font style, font color drop-down list, etc.
Combo in Excel - step 14
  • Step 5: We need to change the combo box’s name.
Change the name of the combo box
  • Step 6: Also, we must change the font type and size.
Change the font type and size
  • Step 7: Next, select the number of rows.
Select the number of rows
  • Step 8: Select “MatchEntry” mode.
Match Entry mode on
  • Step 9: Then, give a link to the cell. So whatever the value we select from the drop-down will reflect in that cell as a value. In this example, the cell is E8.
properties window
  • Step 10: Exit from the “Properties” window and exit the “Design Mode.” That means the design of this combo box is completed. If we again want to redesign, we must click on this “Design Mode.”
Combo in Excel - step 20

Recommended Articles

This article is a guide to Combo Box in Excel. We discuss about how to create Form Control Combo Box and Active X Control Combo Box in Excel VBA with examples. You may also look at these useful functions in Excel: –