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

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