Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Option Buttons
When using activeX control's option buttons in a grouping (from the control
toolbox - not the forms toolbox), how and where do you store the results of which option button they chose? Thanks, Diane |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Option Buttons
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Option Buttons
You're using the .GroupName property to group those optionbuttons, right?
You can also use the .linkedcell property (different for each checkbox--not just different for each group), then use a formula to return which one was selected. I put 3 optionbuttons from the control toolbox toolbar on a worksheet. I assigned all three the same .groupname (Group1). And I linked the first to A1, the second to A2 and the last to A3. =if(a1=true,"First",if(a2=True,"Second","Third")) or =if(a1,"First",If(a2,"Second","Third")) === Or =match(true,a1:a3,0) to return a number. ============== Yep, they behave differently from the optionbuttons from the Forms toolbar. dread wrote: When using activeX control's option buttons in a grouping (from the control toolbox - not the forms toolbox), how and where do you store the results of which option button they chose? Thanks, Diane -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Option Buttons
use the control source property to link them to separate cells
or (you rarely do both) Use the click event (or other event) of each control to take the appropriate action. or in other code, check the controls to see whether they are selected or not. -- Regards, Tom Ogilvy "dread" wrote in message ... When using activeX control's option buttons in a grouping (from the control toolbox - not the forms toolbox), how and where do you store the results of which option button they chose? Thanks, Diane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Option buttons | Excel Programming | |||
ActiveX Option buttons | Excel Programming | |||
ActiveX Option buttons | Excel Programming | |||
Option Buttons -ActiveX | Excel Programming | |||
ActiveX Option Buttons all act as one group | Excel Programming |