Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2018, 10:12 AM
Clema5 Clema5 is offline Check boxes in Word Windows 10 Check boxes in Word Office 2016
Novice
Check boxes in Word
 
Join Date: Oct 2018
Posts: 3
Clema5 is on a distinguished road
Default Check boxes in Word

I am creating a table in Word 2016. I have four columns and each column has a series of check boxes. I need to have a "Total" cell on the bottom of each column to total the number of boxes checked in each respective column. I have figured out how to total all checked boxes but I need four separate columns totaled. Additionally, I can run the macro and it shows me the number, but I need it to print in a line entitled "TOTAL". Any help would be appreciated.
Reply With Quote
  #2  
Old 10-12-2018, 02:06 PM
macropod's Avatar
macropod macropod is offline Check boxes in Word Windows 7 64bit Check boxes in Word 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

Since you haven't told us what kind of checkboxes you're using, attached the document to a post, or even posted your code, it's impossible to advise on what you need to do. That said, see:
https://www.msofficeforums.com/word-...html#post33489
https://www.msofficeforums.com/word-...tml#post107008
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-12-2018, 02:24 PM
Clema5 Clema5 is offline Check boxes in Word Windows 10 Check boxes in Word Office 2016
Novice
Check boxes in Word
 
Join Date: Oct 2018
Posts: 3
Clema5 is on a distinguished road
Default

Thanks for your help. I have tried to figure this out using box regular check boxes and Active X check boxes. Attached is an example of the one with the Active X. I am trying to add the number of checks in the column, hopefully that makes sense.
Attached Files
File Type: docx Example.docx (178.8 KB, 13 views)
Reply With Quote
  #4  
Old 10-12-2018, 03:37 PM
macropod's Avatar
macropod macropod is offline Check boxes in Word Windows 7 64bit Check boxes in Word 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

There seems to be a fundamental flaw in your document's logic, in that you're allowing multiple checkboxes (or none) to be selected for each item. You also previously said:
Quote:
I can run the macro and it shows me the number
but your attachment contains no macros; indeed, being a docx file, it cannot.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-01-2018, 12:32 PM
Clema5 Clema5 is offline Check boxes in Word Windows 10 Check boxes in Word Office 2016
Novice
Check boxes in Word
 
Join Date: Oct 2018
Posts: 3
Clema5 is on a distinguished road
Default Check Boxes

I am attaching the document I am attempting to add the check boxes for. I will obviously lock it for a form document and I haven't finished completing the check boxes yet because I was trying to see if I could get it to work. So, there are 4 columns which I and how many ever rows there are. I want to be able to check only one box in each row and then at the end count the number of boxes check in each column. I have researched and I'm either not asking the question right or perhaps what I'm trying to do can't be done unless I use Excel. Not sure but really appreciate any help I can get.
Attached Files
File Type: docx SERMON EVAULATION FORM 11.1.18.docx (24.7 KB, 18 views)
Reply With Quote
  #6  
Old 11-01-2018, 01:10 PM
macropod's Avatar
macropod macropod is offline Check boxes in Word Windows 7 64bit Check boxes in Word 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

Quote:
Originally Posted by Clema5 View Post
I want to be able to check only one box in each row and then at the end count the number of boxes check in each column.
The document attached to the first link I posted (https://www.msofficeforums.com/word-...html#post33489) shows how to make the checkboxes on each row exclusive; only minor edits of the Document_ContentControlOnExit macro would be needed for your purposes. The Tally macro would need more substantial modification for your purposes, but even that demonstrates the principles involved.

Once again, your attachment is in the docx format. Hence, it contains no code that could be evaluated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
check boxes, column totals

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check boxes in Word check boxes slimjen Word 4 02-13-2018 03:26 PM
Word document with check boxes JohnW Word 3 12-01-2016 07:43 AM
Check boxes in Word Legacy check boxes not working Word 2013 lostenfeld Word 3 07-07-2016 10:58 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:15 AM.


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