Is it possible to have two groups of radio buttons on a worksheet?

[Bob Arnett]

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?

 

[Luke M]

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.

 

[T. Valko]

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.

 

[Bob Arnett]

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.

 

[T. Valko]

You need some VBA code to do that. See this thread:

http://tinyurl.com/4p5esj

 

[Bob Arnett]

Great, that works, too.

You need some VBA code to do that. See this thread:

http://tinyurl.com/4p5esj