Microsoft Office Tutorials and References
In Depth Information
Using the Button Control
Using the Button Control
The button control gives your audience a clear and easy way to execute the macros you’ve recorded.
To insert and configure a button control, follow these steps:
1. Select Insert drop-down list under the Developer tab.
2. Select the button Form control.
3. Click the location in your spreadsheet where you want to place your button.
The Assign Macro dialog box appears and asks you to assign a macro to this button (see
Figure 12-5).
4. Edit the text shown on the button by right-clicking the button, highlighting the existing text,
and then overwriting it with your own.
Figure 12-5: Assign a macro to the newly added button.
To assign a different macro to the button, simply right-click and select Assign Macro to
reactivate the Assign Macro dialog box, as shown in Figure 12-5.
Tip
Using the Check Box Control
The check box control provides a mechanism for selecting/deselecting options. When a check box is
selected, it returns a value of True. When it isn’t selected, False is returned. To add and configure a
check box control, follow these steps:
1. Select the Insert drop-down list under the Developer tab.
2. Select the check box Form control.
Search JabSto ::




Custom Search