Problem with Radio Button's format control

[darcyfournier]

I am creating an employee evaluation template (a sample is below)

Column A is the category

Column B, C D, E and F will be ratings (unacceptable, below, meets, exceeds, outstanding) with radio button options.

Column E is the ratings total for whatever rating above is selected 1-5 because their are 5 options

In the the first category Attire- it works perfectly. No matter what I select, it places the right value in BOX E in that row. If I select Unacceptable, it puts a 1 there..if I selected Outstanding it puts a 5.

However- when doing the same thing for the next category in the row below (Qaulity of work), instead of putting a 1-5, it adds one and my values are now 6-10.

How do I get the options buttons to only be 1-5 for each row?

 

[darcyfournier]

Really? No one has an answer?

 

[My Aswer Is This]

Really? No one has an answer?

I looked at your question yesterday but I surely do not understand what your wanting.

Do you plan to have option buttons on every row of your worksheet.

And maybe if you told us the ultimate goal we may have a better way of doing this

 

[Fluff]

You need to put them in a Form control Group Box

 

[DanteAmor]

Review the following to add a groupbox

Checkboxes Yes No

Hello, I have the following code that I picked up from some web page. This one inserts only one button to the left of the cell. I would like to have two checkboxes in one cell, one for "Yes" another for "No" and only one can be checked. I tried to replicate second option by adding "1" to the...

www.mrexcel.com

Or you can also use Optionbutton Control ActiveX and put a name in the GroupName property for each pair of optionbuttons (category).

 

[darcyfournier]

Sorry all..I am trying to explain this as best I can, my apologies. let me try again.

"My answer is this" Thank you for your question for clarity- Yes, I intend to have option buttons on every row unless there is a better way to do this.

Fluff- I have not used group boxes before, and I would love to learn! Thank you.

Dante Amor- thank you for your reply, I will read that suggestion after I post the clarity below.


I am creating an evaluation template that will have rows of categories

Column A- Criteria B- Poor C- Below D -Meets E-Exceeds F- Outstanding G- Rating

A2- Work Quality b-2 Option Button Poor C- Option Button-below etc. which will place the value of the button selected (1-5) in that row in column G (rating total)

When I do row A2- it works perfectly. B2- Poor returns a "1" in the G rating box, C2 returns a "2" etc.

However, when doing this Row 3 instead of getting a 1-5 for the same categories, I am getting 6,7,8,9,10.

I am trying to have each row only return a 1-5.

How would I do this? I am going to have about 30-40 rows of eval criteria.

Thank you all so much!

 

[Fluff]

Rather than using loads of option buttons, why not just put an X into a cell with a formula in col G

Book1
	A	B	C	D	E	F	G
1
2		x					1
3			x				2
4
5						X	5
6					X		4
Sheet2

Cell Formulas
Range	Formula
G2:G6	G2	=IFERROR(MATCH("x",B2:F2),"")

 

[Fluff]

Or to prevent people selecting more than one cell

Book1
	A	B	C	D	E	F	G
1
2		x					1
3			x				2
4
5						X	5
6				x	X		Select 1 cell only
Sheet2

Cell Formulas
Range	Formula
G2:G6	G2	=IF(COUNTIF(B2:F2,"x")<=1,IFERROR(MATCH("x",B2:F2),""),"Select 1 cell only")

 

[darcyfournier]

Rather than using loads of option buttons, why not just put an X into a cell with a formula in col G

Book1
	A	B	C	D	E	F	G
1
2		x					1
3			x				2
4
5						X	5
6					X		4
Sheet2

Cell Formulas
Range	Formula
G2:G6	G2	=IFERROR(MATCH("x",B2:F2),"")

Thank you for this...I am trying to make the evaluation page as less manual input as possible as the evaluator has to manually enter notes on the performance plan and summary pages that follow it.

 

[darcyfournier]

Or to prevent people selecting more than one cell

Book1
	A	B	C	D	E	F	G
1
2		x					1
3			x				2
4
5						X	5
6				x	X		Select 1 cell only
Sheet2

Cell Formulas
Range	Formula
G2:G6	G2	=IF(COUNTIF(B2:F2,"x")<=1,IFERROR(MATCH("x",B2:F2),""),"Select 1 cell only")

Thank you for this...I really want the evaluator to be able to click the rating without manual input due to the amount of manual input they will need to enter in pages two and three (action plan and summary).