Adding Controls

As discussed in Chapter 1, you can add two different types of controls to Excel worksheets: ActiveX controls or Form controls. The Form controls originated in Excel 5 and Excel 95 and provide controls for the dialog sheets used in those versions, as well as controls embedded in a worksheet or chart. Dialog sheets have been superseded by UserForms since the release of Excel 97, and UserForms utilize the ActiveX controls.

You can create controls by activating the Developer tab of the Ribbon and clicking the Insert button in the Controls group. This displays the dialog box shown in Figure 10-1.

Form Controls

ActiveX Controls

JFusj^ -Figure 10-1

0 0

Post a comment