Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
option buttons | Excel Worksheet Functions | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Option Buttons | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) |