Hello,
I have a form that I'm working on for my company that I believe requires macros in order to assign checkbox rows to numbers in order to do a final calculation at the end of the form. Usually I would do things like this through excel, but the request was for word only.
I've seen past post such as the one below, but can't figure out how it all works as I'm not very good with vba, macros, etc.
https://www.msofficeforums.com/word-...html#post33489
Below is an explanation as to how the form is laid out. I also attached the document for your review.
Note: Checkbox Yes and N/A have a value of 1, while No equals 0
- I have 5 columns, with 14 rows.
- The first column is just the basic question. columns 2-4 are checkboxes relating to the question, and column 5 is where the number is posted.
- Each row is the same in terms of question, checkboxes, and number result.
- Towards the end, row 13 titled Subtotal will calculate the total numbers tallied on the right side of each row.
- The last row is to calculate the subtotal out of the total questions and turn it into a percentage.
Any assistance with this would be much appreciated.
Thank you.