Excel- option button
 

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.

Excel- option button
 

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.

Excel- option button
 

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.

Excel- option button
 

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.

Excel- option button
 

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.

Excel- option button
 

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.

Excel- option button
 

I work in Customer Service. This is part of a list of information our agents
confirm with the customer for Standards of Performance. The agent would ask
them,

1. Style Name and then the Supervisor checks off Yes (which equals 2 pts)
or No (which equals 1 pt) then after all the questions are asked (5 of which
are listed below) then the points are added up. This form is actually 2 pgs
long. In years past we have printed this form off, we are now going
paperless in our office to save trees and let Excel to the figures. I could
send you the file if it would help if you'll tell me how to attach files.
(This is my first time using the message boards) I really thank you for
sticking with me and trying to help me with this.

"T. Valko" wrote:

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.

Excel- option button
 

Send a copy of the file to me and I'll take a look. I'm at

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"Excel Master Wannabe" wrote
in message ...
I work in Customer Service. This is part of a list of information our
agents
confirm with the customer for Standards of Performance. The agent would
ask
them,

1. Style Name and then the Supervisor checks off Yes (which equals 2
pts)
or No (which equals 1 pt) then after all the questions are asked (5 of
which
are listed below) then the points are added up. This form is actually 2
pgs
long. In years past we have printed this form off, we are now going
paperless in our office to save trees and let Excel to the figures. I
could
send you the file if it would help if you'll tell me how to attach files.
(This is my first time using the message boards) I really thank you for
sticking with me and trying to help me with this.

"T. Valko" wrote:

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.