View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marf marf is offline
external usenet poster
 
Posts: 6
Default Option box question

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...