Microsoft Office Tutorials and References
In Depth Information
Getting Started with Form Controls
Adding a control to a worksheet
To add a control to a worksheet, simply click the control that you require and click the approximate
location that you want to place the control. You can easily move and resize the control later just as
you would a chart or shape.
After you add a control, you want to configure it to define its look, behavior, and utility. Each control
has its own set of configuration options that allows you to customize it for your purposes. To get to
these options, right-click the control and select Format Control. This opens the Format Control dialog
box (illustrated in Figure 12-4) with all the configuration options for that control.
Figure 12-4: Right-click and select Format Control to open a dialog box with the configuration options.
Each control has its own set of tabs that allows you to customize everything from formatting, to
security, to configuration arguments. You’ll see different tabs based on which control you’re using,
but most Form controls have the Control tab. The Control tab is where the meat of the configuration
lies. Here, you find the variables and settings that need to be defined in order for the control to
The button and label controls don’t have the Control tab. They have no need for
one. The button simply fires whichever macro you assign it. As for the Label, it’s not
designed to run macro events.
Throughout the rest of the chapter, you walk through a few exercises that demonstrate how to
use the most useful controls in a reporting environment. At the end of this chapter, you’ll have
a solid understanding of Form controls and how they can enhance your dashboards and reports.