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”.
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.
In the following window, choose the “Control” tab and 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.