About combo box
2 Answer(s)
Vidya
If you want to add a ComboBox to one of your worksheets, in order to have some additional options (drop-down list), here's the procedure:
First you must create the list of items you want to have in your ComboBox.
Create this list somewhere on your worksheet
Activate the Developer Tab.
Office(orb) button/Excel Options/ POpular / check Show Developer tab in the ribbon.
Click on the Developer tab
In the Controls Section click on the Insert button and select the Combo Box tool.
You'll notice that the mouse pointer changes to a small crosshair.
To create the combo box click and drag the mouse button on an empty space of your work sheet. Once you obtain the desired size (height X Length) release the mouse button and the combo box will appear in your worksheet.
Right-click on the combo box/Context menu appears/ select the last option Format Control
In the windows that open simply input the cell range define earlier (list of options to be displayed in the combo box).
Jan 13 2014 07:15 AM
First you must create the list of items you want to have in your ComboBox.
Create this list somewhere on your worksheet
Activate the Developer Tab.
Office(orb) button/Excel Options/ POpular / check Show Developer tab in the ribbon.
Click on the Developer tab
In the Controls Section click on the Insert button and select the Combo Box tool.
You'll notice that the mouse pointer changes to a small crosshair.
To create the combo box click and drag the mouse button on an empty space of your work sheet. Once you obtain the desired size (height X Length) release the mouse button and the combo box will appear in your worksheet.
Right-click on the combo box/Context menu appears/ select the last option Format Control
In the windows that open simply input the cell range define earlier (list of options to be displayed in the combo box).
Binny
To create a combo box in Excel:
1) First activate the Developer Tab:
Office button/Excel Options/ POpular / check Show Developer tab in the ribbon.
2) Click on the Developer tab
3) In the Controls Section click on the Insert button and select the Combo Box tool.
May 26 2014 12:48 PM
1) First activate the Developer Tab:
Office button/Excel Options/ POpular / check Show Developer tab in the ribbon.
2) Click on the Developer tab
3) In the Controls Section click on the Insert button and select the Combo Box tool.