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. 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.
Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list.
