Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I created a form with the option button feature from the forms toolbar. I
have them grouped for different questions selections,but it won't isolate for each group it will only select one for the whole worksheet. I need them to be able to do one selection for each question. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Are you using the groupbox for each set of buttons?
-- Regards, Peo Sjoblom "sabrina" wrote in message ... I created a form with the option button feature from the forms toolbar. I have them grouped for different questions selections,but it won't isolate for each group it will only select one for the whole worksheet. I need them to be able to do one selection for each question. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is an example
1.) (inserted option button) Approved (inserted option button) Pending (Inserted option button)Rejected 2) (Inserted option button)Received (Inserted option button)In progress (Inserted option button)Not Received The issue is that I have these all over my worksheet but when someone goes to select an option it will only select one for the whole worksheet, when I need to have it select one for each question (group) throughout the worksheet. "Peo Sjoblom" wrote: Are you using the groupbox for each set of buttons? -- Regards, Peo Sjoblom "sabrina" wrote in message ... I created a form with the option button feature from the forms toolbar. I have them grouped for different questions selections,but it won't isolate for each group it will only select one for the whole worksheet. I need them to be able to do one selection for each question. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You need to use the group box to make them independent of each group, it's
in the same forms toolbar, just grab a hold of it with the mouse and drag it around the 3 option buttons, do the same for all of the groupings. -- Regards, Peo Sjoblom "sabrina" wrote in message ... Here is an example 1.) (inserted option button) Approved (inserted option button) Pending (Inserted option button)Rejected 2) (Inserted option button)Received (Inserted option button)In progress (Inserted option button)Not Received The issue is that I have these all over my worksheet but when someone goes to select an option it will only select one for the whole worksheet, when I need to have it select one for each question (group) throughout the worksheet. "Peo Sjoblom" wrote: Are you using the groupbox for each set of buttons? -- Regards, Peo Sjoblom "sabrina" wrote in message ... I created a form with the option button feature from the forms toolbar. I have them grouped for different questions selections,but it won't isolate for each group it will only select one for the whole worksheet. I need them to be able to do one selection for each question. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Got it, thank you, I knew it was something easy.
"Peo Sjoblom" wrote: You need to use the group box to make them independent of each group, it's in the same forms toolbar, just grab a hold of it with the mouse and drag it around the 3 option buttons, do the same for all of the groupings. -- Regards, Peo Sjoblom "sabrina" wrote in message ... Here is an example 1.) (inserted option button) Approved (inserted option button) Pending (Inserted option button)Rejected 2) (Inserted option button)Received (Inserted option button)In progress (Inserted option button)Not Received The issue is that I have these all over my worksheet but when someone goes to select an option it will only select one for the whole worksheet, when I need to have it select one for each question (group) throughout the worksheet. "Peo Sjoblom" wrote: Are you using the groupbox for each set of buttons? -- Regards, Peo Sjoblom "sabrina" wrote in message ... I created a form with the option button feature from the forms toolbar. I have them grouped for different questions selections,but it won't isolate for each group it will only select one for the whole worksheet. I need them to be able to do one selection for each question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remove multiple option buttons at one time | Excel Discussion (Misc queries) | |||
Two Groups of Option Buttons on Worksheet | Excel Discussion (Misc queries) | |||
How do you set mutliple groups of radio buttons? | Excel Discussion (Misc queries) | |||
Option Buttons - groups | Excel Discussion (Misc queries) | |||
How do I create a form in a worksheet with control option buttons. | New Users to Excel |