What you have to do for Yes = 2 and No = 1 is list No first:

..............I..................J
12.....O No..........O Yes

To isolate each row of buttons from every other row you have to group them.
Use a Group Box from the Forms toolbar and "draw" the Group Box around each
set of buttons.

Biff

"Excel Master Wannabe" <Excel Master
wrote in message ...
I have an Excel spreadsheet that I want to add option buttons to, so that
when the word Yes is selected it will have the value 2 and No have the
value
1. Also, if I have Yes option in Column I Row 12 and No in Column J Row
12,
then under that have a Yes/No option, how can I have it so there is more
than
one selection. It's like out of 24 buttons only one can be selected.