How to add Excel 2007 Combo Box

In this video tutorial we will show you how to add Excel combo box.



In order to add excel combo box, open the Microsoft Excel. For example, select B5 cell and type “name”. Go to the “Developer” tab, click “Insert” and choose “combo box”.
Choose combo box

Select an area where you want place the “combo box”.
Go to “Sheet2” and type names. Go back to “sheet1” and click on “Properties” of the combo box.
Click on Properties

In the following window, choose the “Control” tab and click on “input range”.
Click on input range

Go to the “sheet2” and select cells with names. Then, choose “cell link” and press “ok”. Now, when selecting names in combo box, numbers will be shown in chosen link.