Add a list box to a worksheet

1. Create a list of items that you want to displayed in your list box like in this picture.
2. Click Developer > Insert.
3. Under Form Controls, click List box (Form Control).
4. Click the cell where you want to create the list box.
5. Click Properties > Control and set the required properties:

You can use List Box controls to allow your Excel dashboard and report users to select from a list of predefined choices. When an item from the List Box control is selected, some action is taken with that selection.

Step 1: Go to Developer Tab > Controls > Insert > Form Controls > List Box. Step 2: Click on List Box and draw in the worksheet; then Right-click on the List Box and select the option Format Control.

1. On the Developer tab, click Insert in the Controls group.
2. In the Form Controls group, click the spin button or scroll bar icon, and then click on the worksheet where you want to place the control.
3. Right-click the control and choose Format Control.

Create a List Box on the Worksheet

1. On the Excel Ribbon, click the Developer tab.
2. Click Insert, then click the ListBox control tool.
3. On the worksheet, draw a rectangle with the List Box tool, to create the List Box.
4. With the List Box selected on teh worksheet, click the Properties command on the Ribbon’s Developer tab.

Add an ActiveX control

1. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, select a control, or click More Controls to view all the available ActiveX controls, and then select a control.
2. Click the worksheet location where you want the ActiveX control to appear.

Generally, a combo box is appropriate when there is a list of suggested choices, and a list box is appropriate when you want to limit input to what is on the list. A combo box contains a text box field, so choices not on the list can be typed in.

Step 2: In the Developer tab, click on Insert, followed by the “list box” control. This inserts a new list box in the Excel worksheet. Step 3: Draw a rectangle in the Excel worksheet to create a list box, as shown in the following image. Step 4: Select the list box, go to the Developer tab, and select “properties”.

In the Main Tabs list, check the Developer box, and then click OK. Under Form Controls, click List box (Form Control). Click the cell where you want to create the list box.

Form controls are not as flexible as ActiveX controls but are compatible with earlier versions of Excel. You can find the controls on the developer tab. 1. Create a List Box Steps to build a List Box:

Format a Form Control combo box 1 Right-click the combo box and pick Format Control. 2 Click Control and set the following options: Input range: Type the range of cells containing the list of items. 3 Click OK.

1 Right click on List Box. 2 Click “Format Control…”. 3 Go to tab Control. 4 Click Multi in “Selection type” window. 5 Click OK button.