XL: How to Assign a Macro to an Option ButtonLast reviewed: February 2, 1998Article ID: Q141689 |
The information in this article applies to:
SUMMARYIn Microsoft Excel, you can assign a macro to a custom option button so that when the option button is selected, the macro is run.
MORE INFORMATIONTo create an option button, make sure the Forms toolbar is visible. In Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, point to Toolbars on the View menu, and then click Forms. To display the Forms toolbar in Microsoft Excel versions 5.0 and 7.0, follow these steps:
REFERENCES
Microsoft Excel Version 7.0For more information about assigning a macro to a control, click Answer Wizard on the Help menu and type:
how do I assign a macro to a controlMicrosoft Press: "Microsoft Excel/Visual Basic Programmer's Guide," version 7.0, Chapter 8, "Controls and Dialog Boxes"
Microsoft Excel Version 5.0"Visual Basic User's Guide," version 5.0, Chapter 11, "Controls and Dialog Boxes" For more information about Assigning a Macro to a Control in Microsoft Excel version 5.0, choose the Search button in Help and type:
option buttons, creating |
Additional query words: 5.00 5.00a 5.00c 7.00 8.00 XL97 assigning
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |