#1
|
|||
|
|||
QA Table to Calculate Checked Items into Total Percentage
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
Any assistance with this would be much appreciated. Thank you. |
#2
|
||||
|
||||
Instead of using three checkboxes, you should use a single dropdown with the three choices. That way, you don't need code to ensure two or more mutually-exclusive options aren't chosen. Furthermore, if you create the entire form using formfields instead of content controls, the whole lot can be done without VBA - using just field coding. To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum: Microsoft Word Field Maths Tutorial
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Total Checked FF Check Boxes | CarlCR | Word Tables | 2 | 07-13-2016 12:01 PM |
Text Form Field -Calculate Percentage | Perk | Word | 5 | 04-18-2016 09:05 PM |
Pivot Table - How to calculate from Grand Total field | LoriD | Excel | 0 | 06-15-2015 07:05 PM |
how to show total of check boxes checked | worder | Word | 16 | 03-10-2014 05:07 PM |
How to total 12 columns and divide them to get a percentage | Triscia | Word Tables | 1 | 01-15-2013 07:39 AM |