Problem with Radio Button's format control

darcyfournier

Board Regular
Joined
Nov 21, 2017
Messages
54
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?


1575601743795.png
 

Attachments

Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,272
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,151
Office Version
365
Platform
Windows
You need to put them in a Form control Group Box
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
8,791
Office Version
2007
Platform
Windows
Review the following to add a groupbox


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

darcyfournier

Board Regular
Joined
Nov 21, 2017
Messages
54
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,151
Office Version
365
Platform
Windows
Rather than using loads of option buttons, why not just put an X into a cell with a formula in col G

xl2bb.xlam
ABCDEFG
1
2x
3x
4
5X
6X
Sheet2
Cell Formulas
Range(s)Formula
G2:G6G2=IFERROR(MATCH("x",B2:F2),"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,151
Office Version
365
Platform
Windows
Or to prevent people selecting more than one cell

xl2bb.xlam
ABCDEFG
1
2x
3x
4
5X
6xX
Sheet2
Cell Formulas
Range(s)Formula
G2:G6G2=IF(COUNTIF(B2:F2,"x")<=1,IFERROR(MATCH("x",B2:F2),""),"Select 1 cell only")
 

darcyfournier

Board Regular
Joined
Nov 21, 2017
Messages
54
Rather than using loads of option buttons, why not just put an X into a cell with a formula in col G

xl2bb.xlam
ABCDEFG
1
2x
3x
4
5X
6X
Sheet2
Cell Formulas
Range(s)Formula
G2:G6G2=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

Board Regular
Joined
Nov 21, 2017
Messages
54
Or to prevent people selecting more than one cell

xl2bb.xlam
ABCDEFG
1
2x
3x
4
5X
6xX
Sheet2
Cell Formulas
Range(s)Formula
G2:G6G2=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).
 

Forum statistics

Threads
1,081,855
Messages
5,361,714
Members
400,648
Latest member
dalviaks

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top