Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
active x radio buttons in excel
Hi, I've created a group box and put 3 radio buttons inside it - I want to
only be able to select one of the three radio buttons but at the moment I am able to select 2 at a time - how can I get around this? Thanks :-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
active x radio buttons in excel
Since you used a groupbox, how about using the optionbuttons from the Forms
toolbar. If you want the optionbuttons from the control toolbox toolbar, then you don't need the groupbox. But you do have to change the .groupname property of each optionbutton to be the same. (Each group of optionbuttons should have its own unique groupname.) Anna wrote: Hi, I've created a group box and put 3 radio buttons inside it - I want to only be able to select one of the three radio buttons but at the moment I am able to select 2 at a time - how can I get around this? Thanks :-) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
active x radio buttons in excel
Thanks, I think i understand what you're saying, but how do I do this?
Thank you! "Dave Peterson" wrote: Since you used a groupbox, how about using the optionbuttons from the Forms toolbar. If you want the optionbuttons from the control toolbox toolbar, then you don't need the groupbox. But you do have to change the .groupname property of each optionbutton to be the same. (Each group of optionbuttons should have its own unique groupname.) Anna wrote: Hi, I've created a group box and put 3 radio buttons inside it - I want to only be able to select one of the three radio buttons but at the moment I am able to select 2 at a time - how can I get around this? Thanks :-) -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
active x radio buttons in excel
Sometimes this happens when one of your buttons is not totally inside the
frame (not just the button itself but the whole "box" including the label that highlights when you select the button in design mode). "Anna" wrote: Hi, I've created a group box and put 3 radio buttons inside it - I want to only be able to select one of the three radio buttons but at the moment I am able to select 2 at a time - how can I get around this? Thanks :-) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
active x radio buttons in excel
Click on the Design mode icon on that control toolbox toolbar.
Rightclick on each of the optionbuttons and show properties. Change the GroupName in that dialog. (Same groupname for each optionbutton in that group.) anna wrote: Thanks, I think i understand what you're saying, but how do I do this? Thank you! "Dave Peterson" wrote: Since you used a groupbox, how about using the optionbuttons from the Forms toolbar. If you want the optionbuttons from the control toolbox toolbar, then you don't need the groupbox. But you do have to change the .groupname property of each optionbutton to be the same. (Each group of optionbuttons should have its own unique groupname.) Anna wrote: Hi, I've created a group box and put 3 radio buttons inside it - I want to only be able to select one of the three radio buttons but at the moment I am able to select 2 at a time - how can I get around this? Thanks :-) -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radio Buttons in Excel 2007 | New Users to Excel | |||
how do I get radio buttons in excel | Excel Discussion (Misc queries) | |||
How do I set up radio buttons in excel 2007? | Excel Discussion (Misc queries) | |||
add radio buttons to an excel document | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |