Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Each control has its own events because it is a separate object. If you
want to perform an action based on a click event of the control, the code must be tied to the control performing the event. So the short answer is you have to write code for each control. "Ayo" wrote in message ... I have a Frame with about 10 Optionbuttons. I am trying to figure out a way such that when I click on any of the option buttons, something is done. I can't figure out how to do this without having to write 10 of this: Private Sub OptionButton1_Click() End Sub Is there a way to do it all in one procedure instead of 10? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Buttons disappear from the frame when not in design mode | New Users to Excel | |||
Accessing every option button on a frame | Excel Programming | |||
Enable target frame option | Excel Discussion (Misc queries) | |||
deselect all option buttons in a frame | Excel Programming | |||
multipage - option buttons disappear from frame in Excel 2003 | Excel Programming |