Assigning Values to content control checkboxes and calculating results in Word

[annieruok8]

Hi, need to assign values to the checked boxes (5-1 as the rating points) and calculate the count of total performance evaluation in the overall rating box. How do I create using a macro?

[Guessed]

It appears that you want five different overall ratings and I don't see how that would be useful. Have a think about how you would calculate a SINGLE overall rating. Looking at the form, I would say the two most important factors in an overall rating are probably the Current Error Rate and the Benchmark Range - are these part of your overall rating calculations.

I would also recommend you get rid of the performance check boxes and replace them with a dropdown against each of the factors. Check boxes allow users to choose more than one value which shouldn't be possible. Having five columns also doesn't leave much space for comments which a single column would solve. A dropdown would make the calculation of the Overall rating a lot simpler.

[annieruok8]

I would like to total the number of boxes that are checked for each overall rating column with the assistance of a macro to calculate the column count.

The current error rate and benchmark range do not play into the overall rating calculations.

[macropod]

See, for example:
https://www.msofficeforums.com/word-...g-results.html
https://www.msofficeforums.com/word-...culations.html