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:

  1. Click the Data tab.

  2. 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 2007 and Excel 2010.

Figure 13-4. AutoFilter ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.