| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to assign a macro to hundreds of option buttons at once
I have hundreds of option buttons that need to have the same macro assigned
to each (too many to do manually). I am doing this so that when a button is selected it will change a cell in the worksheet and run a worksheet change macro. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to assign a macro to hundreds of option buttons at once
If you want to assign the same macro to all (Forms style) optionbutons on
the sheet, simply ActiveSheet.OptionButtons.OnAction = "myMacro" Otherwise you will need to loop option buttons looking for something particular about one of the properties to dictate the OnAction string. In passing, if you mean call worksheet change event code I doubt that's the best approach. Regards, Peter T "Carl" wrote in message ... I have hundreds of option buttons that need to have the same macro assigned to each (too many to do manually). I am doing this so that when a button is selected it will change a cell in the worksheet and run a worksheet change macro. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign different buttons by Macro | Excel Discussion (Misc queries) | |||
| Code for creating option buttons | Excel Programming | |||
| How to assign different Linked cells to option buttons | Excel Programming | |||
| How to assign same code inside Option button code space ?? | Excel Programming | |||
| option buttons run Click code when value is changed via VBA code | Excel Programming | |||
Hybrid Mode
