Page 212 - Excel Data Analysis

11 537547 Ch10.qxd 3/4/03 12:03 PM Page 198

EXCEL DATA ANALYSIS

ADD A FORM CONTROL TO A WORKSHEET

ou can add different controls to a worksheet to make properties and size of a form control, but you cannot test
it easier to capture specific values in a field. This in out its functionality. The design mode applies to the forms
Y turn allows you to capture cleaner data to analyze. control that you currently have selected.
For example, you can add a Spinner control to scroll up and When you place a control on a worksheet, it sits on top of
down to select the appropriate numeric value for a cell, and the worksheet. You can size it so that it appears to be
you can add a list box containing the values that a user can located in a specific cell, but it is actually separate from the
select for a cell.
cell. Because the controls are separate from the actual
Excel provides nine different controls that you can add to a worksheet cells, you can place them anywhere on the
worksheet. You add the controls by selecting them from the worksheet. A control can cover any portion of a cell or
Forms toolbar. You then specify the desired control size. range of cells.
Excel enables you to size each control by dragging the After you add controls to a worksheet, you must specify the
edges. You can also use the controls on the Forms toolbar cells containing the data values for the control. Form
to add controls to a Chart sheet.
controls require data values that exist in a worksheet. See
When you add or select a control on a worksheet, Excel is the section "Specify Values for a Form Control" for more
in design mode. In this mode, you can modify the information on specifying control values.

ADD A FORM CONTROL TO A WORKSHEET

⁄ Click View ➪ Toolbars ➪ ■ The Forms toolbar appears. ‹ Drag the cursor on the
Forms. worksheet to set the size of
¤ Click the button of the the control and release the
form control that you want to mouse button.
add.

198