Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-01-2014, 09:02 PM
macropod's Avatar
macropod macropod is offline Calculating values from Drop Down Selections Windows 7 64bit Calculating values from Drop Down Selections Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating values from Drop Down Selections Contact details entered based on multiple drop down selections ntropey87 Word VBA 4 04-20-2013 11:19 AM
Calculating values from Drop Down Selections Drop Down list with calculations and values winter4400 Word 7 01-16-2013 04:55 AM
add values to dropdown selections and calculate guyhs Word 7 10-24-2012 05:11 PM
Calculating values from Drop Down Selections Assigning Values to content control checkboxes and calculating results creative cathy Word Tables 13 10-07-2012 08:52 PM
calculate average depending on drop-down values virencm Word 0 08-06-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.


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