Using Controls
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).
Figure 13-4. AutoFilter ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
