Results 1 to 16 of 16

Thread: SUM values of drop down lists in Word 2010

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #7
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,411
    Location
    What do you mean by "3 quick part drop downs." What is a "quick part dropdown?" Paul's solution is robust and works well. The only drawback is that the calculation/update will not occur unless the user exits the dropdown control after making the selection. Since you can't guarantee a cooperative document user you are left with the possibility of an inaccurate result or writing more code to ensure the calculation/update occurs before printing or saving.


    The method I suggested, while seemingly more complex, will update automatically when the user makes a new selection.

    I put a working example (employee evaluation) in a public dropbox: https://dl.dropboxusercontent.com/u/...xample%29.docm
    Last edited by gmaxey; 06-16-2014 at 01:27 PM.
    Greg

    Visit my website: http://gregmaxey.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •