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?

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?

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?

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?

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?

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?