about combo box
4 Answer(s)
Sandhya
If you want to add a ComboBox to one of your worksheets, in order to hace 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:
In our example we will make use of a list of the types of websites/blogs.
Tech
Sports
Buzz
Finance
Ecommerce
Create this list somewhere on your worksheet,(e.g From cells: E13-E17)
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 cross hair.
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 09 2014 03:57 PM
First you must create the list of items you want to have in your ComboBox:
In our example we will make use of a list of the types of websites/blogs.
Tech
Sports
Buzz
Finance
Ecommerce
Create this list somewhere on your worksheet,(e.g From cells: E13-E17)
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 cross hair.
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).
Manuel
First you must create the list of items you want to have in your ComboBox:
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 cross hair.
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
Jan 10 2014 02:47 PM
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 cross hair.
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
Melvin
if you want to add a ComboBox to one of your worksheets, in order to hace 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:
In our example we will make use of a list of the types of websites/blogs.
Tech
Sports
Buzz
Finance
Ecommerce
Create this list somewhere on your worksheet,(e.g From cells: E13-E17)
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 cross hair.
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 11 2014 12:39 PM
First you must create the list of items you want to have in your ComboBox:
In our example we will make use of a list of the types of websites/blogs.
Tech
Sports
Buzz
Finance
Ecommerce
Create this list somewhere on your worksheet,(e.g From cells: E13-E17)
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 cross hair.
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:
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 25 2014 05:51 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.