Controls can be buttons, list boxes, check boxes, option buttons, and more. They are part of the integrated dialog boxes in Excel. If you use Microsoft Visual Basic for Applications (VBA), you can work with them in user-defined dialog boxes.
Excel uses controls in worksheets. For example, the AutoFilter uses list boxes for filter criteria.
AutoFilter in Excel 2007 and Excel 2010. To set the AutoFilter in Excel 2007 or Excel 2010, follow these steps:
Click the Data tab.
Click the Filter button in the Sort & Filter group. The filter is added automatically and can be used to filter for certain criteria (see Figure 13-4).
AutoFilter in Excel 2003. In Excel 2003, you select Data/Filter/AutoFilter to set the AutoFilter. You can also use custom controls in a worksheet.
52.15.74.25