• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatic Calculation of Scores

butterboxbaby14

New Member
Hi All,

I am trying to create a userform for auditing purposes and I would like it to also show the actual total score being displayed below my userform. So Points Achieved would be the actual score and Points Possible is the Weight, which only shows a value is the attribute is either a Yes or No and blank if NA.

I would like to display the score Achieved/Possible in percentage. It could display the score as I go along the attributes, like if I answer Attribute #1, a score will already be displayed as percentage.

I am very new to userforms so most of my scripts are the long way.

Attached is a sample file.

Thanks you so much in advance
 

Attachments

  • Sample.xlsm
    346.8 KB · Views: 6
Back
Top