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 :-)

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

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

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 :-)

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