Creating new option button groups - how?

[Seamus McMillan]

I have a worksheet with a pair of option buttons
(Male/Female), both referencing the same cell. This
works fine. I now wish to add another pair of buttons
(Yes/No). However when I add a new button (by selecting
the radio button in the Forms toolbar and then clicking
in the sheet) the new button has the same cell reference
as the first pair. When I give it a new cell reference
to create a separate Y/N group, the cell reference in the
first pair of buttons (M/F) also changes so that all
three buttons always have the same cell reference. How
do I deal with this? Any suggestions would be much
appreciated.

TIA

Seamus McMillan

 

[Rafael Ortiz]

You need to use the Group Box (in the Forms toolbar). Each set of option
buttons should go in its own Group box. Just stretch out the Group box
enough to accomodate your buttons.

MRO