Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Gouping for Option Buttons

I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Gouping for Option Buttons

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Mike wrote:

I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Gouping for Option Buttons

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Gouping for Option Buttons

Hi Dave

Thank you for your response. I am able to put a pair of option buttons
inside a group box, however my problem is that when I right click on the
radio button and try to click "grouping", it is greyed out and does not allow
me get in and rename so the two options buttons contained within the group
box stay separate. any ideas what the problem is?

"Dave Peterson" wrote:

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Mike wrote:

I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Gouping for Option Buttons

That kind of grouping is essentially make one shape out of multiple shapes.
Then you can move/size that one shape. This isn't the kind of grouping that you
need.

Mike wrote:

Hi Dave

Thank you for your response. I am able to put a pair of option buttons
inside a group box, however my problem is that when I right click on the
radio button and try to click "grouping", it is greyed out and does not allow
me get in and rename so the two options buttons contained within the group
box stay separate. any ideas what the problem is?

"Dave Peterson" wrote:

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Mike wrote:

I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Gouping for Option Buttons

Hi Peo

Thanks for your replay. Unfortunately, the issue is not the inability for me
to name a group box, the issue is that I have several sets of radio button on
the worksheets with uniquely named group boxes, when I click on a radio
button then click another outside of the groupbox, it unclicks. In other
words, all of my buttons are working in one group no matter what group box
they are in, how do I make each group box work independently?

"Peo Sjoblom" wrote:

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Gouping for Option Buttons

Make sure each of the optionbuttons (from the Forms toolbar) is completely
inside their respective groupboxes.

Mike wrote:

Hi Peo

Thanks for your replay. Unfortunately, the issue is not the inability for me
to name a group box, the issue is that I have several sets of radio button on
the worksheets with uniquely named group boxes, when I click on a radio
button then click another outside of the groupbox, it unclicks. In other
words, all of my buttons are working in one group no matter what group box
they are in, how do I make each group box work independently?

"Peo Sjoblom" wrote:

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike





--

Dave Peterson
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Gouping for Option Buttons

I have done this, still no luck. Something is causing all the buttons on the
worksheet to be inter-related?

"Dave Peterson" wrote:

Make sure each of the optionbuttons (from the Forms toolbar) is completely
inside their respective groupboxes.

Mike wrote:

Hi Peo

Thanks for your replay. Unfortunately, the issue is not the inability for me
to name a group box, the issue is that I have several sets of radio button on
the worksheets with uniquely named group boxes, when I click on a radio
button then click another outside of the groupbox, it unclicks. In other
words, all of my buttons are working in one group no matter what group box
they are in, how do I make each group box work independently?

"Peo Sjoblom" wrote:

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike




--

Dave Peterson

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Gouping for Option Buttons

Doublecheck to see if you are really using optionbuttons from the Forms
toolbar--any chance you used optionbuttons from the Control toolbox toolbar.

Then doublecheck if you have the optionbuttons completely within the
corresponding groupbox.

Try it on a test worksheet to see if you can get it working.

Mike wrote:

I have done this, still no luck. Something is causing all the buttons on the
worksheet to be inter-related?

"Dave Peterson" wrote:

Make sure each of the optionbuttons (from the Forms toolbar) is completely
inside their respective groupboxes.

Mike wrote:

Hi Peo

Thanks for your replay. Unfortunately, the issue is not the inability for me
to name a group box, the issue is that I have several sets of radio button on
the worksheets with uniquely named group boxes, when I click on a radio
button then click another outside of the groupbox, it unclicks. In other
words, all of my buttons are working in one group no matter what group box
they are in, how do I make each group box work independently?

"Peo Sjoblom" wrote:

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike




--

Dave Peterson


--

Dave Peterson
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Gouping for Option Buttons

Thanks Dave, I went ahead and started over and it worked.

Mike

"Dave Peterson" wrote:

Doublecheck to see if you are really using optionbuttons from the Forms
toolbar--any chance you used optionbuttons from the Control toolbox toolbar.

Then doublecheck if you have the optionbuttons completely within the
corresponding groupbox.

Try it on a test worksheet to see if you can get it working.

Mike wrote:

I have done this, still no luck. Something is causing all the buttons on the
worksheet to be inter-related?

"Dave Peterson" wrote:

Make sure each of the optionbuttons (from the Forms toolbar) is completely
inside their respective groupboxes.

Mike wrote:

Hi Peo

Thanks for your replay. Unfortunately, the issue is not the inability for me
to name a group box, the issue is that I have several sets of radio button on
the worksheets with uniquely named group boxes, when I click on a radio
button then click another outside of the groupbox, it unclicks. In other
words, all of my buttons are working in one group no matter what group box
they are in, how do I make each group box work independently?

"Peo Sjoblom" wrote:

Use the options buttons from the forms toolbar, then use a a groupbox from
the
forms toolbar around each set of options buttons, then right click the
border
of the groupbox and select edit text


--


Regards,


Peo Sjoblom



"Mike" wrote in message
...
I am trying to name unique groups for my Option Buttons so each question I
use the buttons for is independent from other buttons, however when I
right
click on the option button, grouping is grayed out. how can I ungray
"grouping" so I can name them. by the way, the ption button I am currently
using is not the ActiveX option. any assistance would be appreciated

Mike




--

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
option buttons CAOU Excel Worksheet Functions 1 April 20th 06 09:17 AM
Option Buttons coryrey Excel Discussion (Misc queries) 1 January 6th 06 03:49 PM
Option Buttons Mike Rogers Excel Discussion (Misc queries) 2 November 21st 05 07:33 PM
Option Buttons Grant90 Excel Discussion (Misc queries) 1 July 29th 05 02:34 PM
yes/no option buttons Evanya Excel Discussion (Misc queries) 4 May 28th 05 12:19 AM


All times are GMT +1. The time now is 05:02 PM.

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

About Us

"It's about Microsoft Excel"