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.

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.

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.

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.

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.

Sorry, not following you on this. ???

Biff

"Excel Master Wannabe" wrote
in message ...
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.