| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to have two groups of radio buttons on a worksheet?
I have two completely unrelated user-defined options on the same worksheet
with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to have two groups of radio buttons on a worksheet?
You said radio button, but do you mean option button?
From the forms toolbar, you can create a group box and then place option buttons inside them. Each group can/will have its own seperate cell link. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bob Arnett" wrote: I have two completely unrelated user-defined options on the same worksheet with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to have two groups of radio buttons on a worksheet?
You need to put each related set of buttons inside a group box from the
Forms Toolbar. The group box isolates the sets from one another. -- Biff Microsoft Excel MVP "Bob Arnett" wrote in message ... I have two completely unrelated user-defined options on the same worksheet with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to have two groups of radio buttons on a worksheet?
Thanks, that did the trick.
I was also wondering if it is possible to make the line around the group box not show like one can do with text boxes, cells, etc. "Bob Arnett" wrote: I have two completely unrelated user-defined options on the same worksheet with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to have two groups of radio buttons on a worksheet?
You need some VBA code to do that. See this thread:
http://tinyurl.com/4p5esj -- Biff Microsoft Excel MVP "Bob Arnett" wrote in message ... Thanks, that did the trick. I was also wondering if it is possible to make the line around the group box not show like one can do with text boxes, cells, etc. "Bob Arnett" wrote: I have two completely unrelated user-defined options on the same worksheet with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to have two groups of radio buttons on a worksh
Great, that works, too.
"T. Valko" wrote: You need some VBA code to do that. See this thread: http://tinyurl.com/4p5esj -- Biff Microsoft Excel MVP "Bob Arnett" wrote in message ... Thanks, that did the trick. I was also wondering if it is possible to make the line around the group box not show like one can do with text boxes, cells, etc. "Bob Arnett" wrote: I have two completely unrelated user-defined options on the same worksheet with each option having a YES radio button and a NO radio button. Unfortunately, I can't seem to get Excel to recognize that there are two independent questions being answered and therefore if any of the four options is selected the other three are deselected. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| how do we establish different groups of radio button in excel | 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) | |||
| VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions | |||
Hybrid Mode
