Below is part of my spreadsheet, they are items that have to be reviewed.
The option buttons are after each item, ex: Style Name Yes=2 No=1--Color
Name & Number Yes No, etc. I have several items that need to be verified so
I need a yes or no allowed on each row. The way it is now I have in this
example 5 responses but my spreadsheet only gives 1--when I select Yes in say
1.c.1 and No in 1.c.2 the first response moves to the second selection. Does
that make any sense?

1.c.1 Style Name
1.c.2 Color Name & Number
1.c.3 Size (Width x Length) or Number of Units
1.c.4 Price
1.c.5 Reference Number
"T. Valko" wrote:

You haven't said how you intend to use the values 1 or 2 but what you could
do is add another button and list it first as a default selection of None.
This would make None = 1, No = 2, Yes = 3.

Biff

"Excel Master Wannabe" wrote
in message ...
Thank you for your help. I do have one more question, by putting NO first
it
automatically assumes the value of 1 or do I need to enter a number in a
cell
to link it?

"T. Valko" wrote:

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.