View Single Post
 
Old 03-31-2019, 02:57 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Create new documents from the template. (File > New) These will be cleared of selections. Select as many or as few check boxes as you wish then click the calculate button. You can make changes and recalculate in that document.

I have modified the attachment slightly. Just re-download and copy the ModMain module to your template (drag and drop with both open) and copy the contents of the ThisDocument module to the matching module in your template.

The Button is an ActiveX button from the Developer Tab, Controls Group and it simply runs the CalculateTotals macro which counts up the various check box results and writes them to the appropriate results content controls and then totals the selections and sorts the results.

It all works on the basis that your check box content controls all have the same titles - in this Case 1,2,3,4,5,6,7,8,9 as appropriate and that the results have corresponding titles Calc1 to 9. There is also a Total content control.

You may find http://www.gmayor.com/insert_content_control_addin.htm useful to edit the controls and add titles as appropriate in your template.
Attached Files
File Type: dotm CheckboxPreferencesExample.dotm (50.5 KB, 41 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote