Excel- option button

[Guest]

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.

 

[T. Valko]

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

 

[Guest]

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]

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

 

[Guest]

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]

Sorry, not following you on this. ???

Biff

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

 

[Guest]

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]

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