Combobox

 

Draw a Combobox    |   Add items to Combobox

An Excel VBA combobox is a drop down list from where the user can make a choice. The difference between a listbox and a combobox is that with a combobox the user can also fill in his/her own choice if it is not included in the list.

Draw a Combobox

Excel 2010 and Excel 2007 users. Click on Insert from the Developer tab and then click on Combo Box in the ActiveX Controls Section.

Create an Excel VBA Combobox in Excel 2010 or Excel 2007

Excel 2003 users. Click on Combo Box from the Control ToolBox.

Create an Excel VBA Combobox in Excel 2003

1. Draw a combobox on your worksheet and enter some names into Range("B2:B4").

Draw a Combobox on your Worksheet

Add items to Combobox

To add some items to the combobox, execute the following steps:

1. Right click on the combobox (make sure design mode is selected) an click on Properties. Fill in E2 for LinkedCell and B2:B4 for ListFillRange.

Add Items to Combobox

2. Choose an item from the combobox or fill in your own choice.

Result:

Excel VBA Combobox Example

Although in some situations it can be useful to directly place a combobox on your worksheet, a combobox is particularly useful when placed on a Userform.

Go to Top: Combobox    |   Go to Next Topic: Checkbox

Learn more >>
Login to our example programs and let us help you become an Excel VBA professional!