Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 132
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 132
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Radio Buttons in Excel 2007 newby New Users to Excel 3 March 31st 10 06:42 PM
how do I get radio buttons in excel Jammings Excel Discussion (Misc queries) 4 June 30th 08 05:53 PM
How do I set up radio buttons in excel 2007? tarndt Excel Discussion (Misc queries) 1 August 14th 07 08:49 PM
add radio buttons to an excel document KENKYL Excel Worksheet Functions 1 May 10th 06 06:22 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"