Option box question

[marf]

I would like to have a table in Excel where the last column for each row is 2
option boxes, one for YES and one for NO.

In other words:

aaa aaa aaa aaa aaa | YES O NO O |
bbb bbb bbb bbb bbb | YES O NO O |
ccc ccc ccc ccc ccc | YES O NO O |

The YES and NO option buttons are in one cell.

All these options buttons are connected somehow, so that only one of them
can be checked for the whole spreadsheet. I would like to set it up so that I
can connect only 1 row at a time, so that if I check YES; NO is unchecked and
vice versa, line by line...

 

[Dave Peterson]

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.