Microsoft Office Tutorials and References
In Depth Information
Use Dialog Box Controls to Input Data
Use Dialog Box Controls
to Input Data
You can make worksheet data entry easier and
more accurate by using dialog box controls
such as check boxes, option buttons, lists, and
If you are building a worksheet for data entry,
your main concerns should be speed and
accuracy. That is, you want users to be able to
input data as quickly as possible, while still
making the entered data as accurate as possible.
The easiest way to achieve both goals in Excel
is to add dialog box controls — also called
form controls — to your worksheet. These are
controls such as check boxes and lists that you
are familiar with from dialog boxes.
The benefit to using form controls is that they
reduce the amount of typing required by the
user entering data. For example, rather than
having the person type Yes or No in a cell,
they can activate or deactivate a check box,
instead. Similarly, rather than having the user
memorize a cell’s possible inputs, you can
provide a list of the allowable values.
To use worksheet form controls, you must first
customize the Ribbon to display the Developer
tab, as described in the first Tip.
Add a Control to a
1 Click the Developer tab.
2 Click Insert.
3 Click the control you
want to add.
In this case, you need to
click a control from the
Form Controls section of
the Insert Controls
4 Click and drag on the
worksheet at the spot
where you want the
control to appear.
● As you drag, Excel
displays the border of
5 When the control is the
size and shape you want,
release the mouse.