Calculating values from Drop Down Selections

Charles Kenyon · #1 12-03-2014, 09:27 AM

Quote:

Originally Posted by bbucher

I really appreciate the feedback.

I tried updating the formfield to the 'calculate on exit', however, I don't see that as an option under Developer, Properties.

How would I convert all drop downs to this format?
How do I create unique internal bookmark names for each drop down? I thought I already completed this (OC1, OC2,...OC7) for the organizational competencies section (Section I), yet it doesn't appear to calculate when adding the formula you sent.

Thank you so much. I am so lost with completing this document.

There is no automated way to convert content control dropdowns to legacy formfield dropdowns. I'm sure someone could come up with a vba method for doing this but it would not be a minor undertaking. If you have hundreds of them, you might want to pay someone (else) to do this. I would not attempt it and expect it would not be cheap. Otherwise, you will need to create new (legacy) formfield dropdowns and delete the existing (content control) ones.

Greg Maxey's Add-In for legacy form fields can be useful. Add Classic FormField Controls to Ribbon

bbucher · #2 12-03-2014, 02:51 PM

Thank you. I deleted the content control boxes and inserted form field drop down boxes, renamed each box and inserted the formula previously provided but I'm receiving the error "!Syntax Error, {" for each calculation. Did I copy the formula incorrectly?

Also, I am not able to select a drop down choice in the form fields. What do I need to do to allow the user to edit the document and be able to select an option from the form fields?

Attached is the updated document for reference.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Contact details entered based on multiple drop down selections	ntropey87	Word VBA	4	04-20-2013 11:19 AM
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
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