To specify the range for the list, type H1:H20 in the Input range box. In the Format Object window, type the following information, and then click OK. In this example, create a list box that covers cells B2:E10. If the Forms toolbar is not visible, point to Toolbars on the View menu, and then click Forms.Ĭlick the worksheet location where you want the upper-left corner of the list box to appear, and then drag the list box to where you want the lower-right corner of the list box to be. To add a list box in Excel 2003 and in earlier versions of Excel, click the List Box button on the Forms toolbar. To add a list box in Excel 2007 and later versions, click the Developer tab, click Insert in the Controls group, and then click List Box Form (Control) under Form Controls. In a new worksheet, type the following items in the range H1:H20: Set up the list, the cell link, and the index To do this, follow these steps:Ĭlick the Microsoft Office Button, and then click Excel Options.Ĭlick Popular, select the Show Developer tab in the Ribbon check box, and then click OK. To use the forms controls in Excel 2007, you must enable the Developer tab. Select the Developer check box under Main Tabs on the right, and then click OK. To use the form controls in Excel 2010 and later versions, you have to enable the Developer tab. The examples use the same list, cell link, and Index function.
#HOW TO ENABLE DEVELOPER TAB IN EXCEL 2010 HOW TO#
The following methods show how to use list boxes, combo boxes, spin buttons, and scroll bars. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars.įor more information about form controls in Excel, see Overview of forms, form controls, and ActiveX controls on a worksheet.
![how to enable developer tab in excel 2010 how to enable developer tab in excel 2010](https://excelatfinance.com/xlf17/media/xlf-2016-data-tab.png)
![how to enable developer tab in excel 2010 how to enable developer tab in excel 2010](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/02/enable-macros-in-excel-example-1.2.png)
Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list.