Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2019, 12:00 PM
artofanime artofanime is offline QA Table to Calculate Checked Items into Total Percentage Windows 10 QA Table to Calculate Checked Items into Total Percentage Office 2019
Novice
QA Table to Calculate Checked Items into Total Percentage
 
Join Date: Oct 2019
Posts: 1
artofanime is on a distinguished road
Default 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
  1. I have 5 columns, with 14 rows.
  2. 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.
  3. Each row is the same in terms of question, checkboxes, and number result.
  4. Towards the end, row 13 titled Subtotal will calculate the total numbers tallied on the right side of each row.
  5. 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.
Attached Files
File Type: docm QA Form DRAFT.docm (34.5 KB, 10 views)
Reply With Quote
  #2  
Old 10-15-2019, 08:40 PM
macropod's Avatar
macropod macropod is offline QA Table to Calculate Checked Items into Total Percentage Windows 7 64bit QA Table to Calculate Checked Items into Total Percentage Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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
QA Table to Calculate Checked Items into Total Percentage How to total 12 columns and divide them to get a percentage Triscia Word Tables 1 01-15-2013 07:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft