View Single Post
 
Old 12-01-2014, 09:02 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Your document uses a mix of content controls (for the dropdowns) and formfields (for the checkboxes). You really shouldn't use content controls and formfields in the same document; they don't work well together and can produce erratic document behaviour.

If you restrict yourself to using just formfields, including for the dropdowns, you can do all the calculations without the need for VBA. You do that by checking each formfield's 'calculate on exit' property, ensuring it has a unique internal bookmark name, then referencing those bookmark names in a formula field that does the tallying. The field code to tally the results would look something like:
{={REF Dropdown1}+{REF Dropdown2}+{REF Dropdown3}+{REF Dropdown4}+{REF Dropdown4} \# 0}
where Dropdown1, etc. are the Dropdown's internal bookmark names.

With content controls, however, you will need VBA.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote