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]

This line of the code Cells(Target.Row, 3).Resize(, 5).ClearContents should clear columns C:G for that row

There must have been something off then, I cut and pasted the code you provided above, and replaced the same code and now it works...for now. Let's see what happens when I save and reopen it.

 

[darcyfournier]

If you close Xl down completely & start it up again & open the file, does it work?

I got it back to working again. SO far so good.

The last piece I am trying to do is to pull any ROW that has below average scores (column c and d) and move them to worksheet three for the evaluator to create a performance plan for those categories.

Any ideas?

 

[Fluff]

As that is completely different question, you will need to start a new thread.
Thanks

 

[darcyfournier]

As that is completely different question, you will need to start a new thread.
Thanks

Understood and done, thanks.

 

[Fluff]

You're welcome & thanks for the feedback