Add Item to COMBOBOX in Excel VBA

COMBOBOX can be used either in worksheet or userform. Combobox ActiveX control is used to store and display the items in a list. A combobox is a drop down list where user can select an item from the list. Follow the below steps to display the combobox in worksheet.

Step 1:

Go to menu bar and click Developer->Insert->ComboBox as shown in the below picture. Click here to insert Developer tab into the menu bar.

Step 2:

After clicking the above option, drag it to desired location in worksheet as shown in the below picture.

Step 3:

To add list of items into the ComboBox, type the values from "A1" to "A6" and right click on the combobox then select the properties option as shown in the below picture.

Step 4:

After clicking the above properties option a window will popup as shown in the below image.

Step 5:

Provide the range (A1:A6) in ListFillRange in properties window as below.

Step 6:

Now close the properties window and change the design mode to off. The list of items will be displayed like below image.

Hope you have understood the concepts. Please provide the feedback on this post and our website if any. Thank You!!!...