S
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
(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