Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-03-2014, 09:27 AM
Charles Kenyon Charles Kenyon is online now Calculating values from Drop Down Selections Windows 7 64bit Calculating values from Drop Down Selections Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,531
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by bbucher View Post
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
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 12:51 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