Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
I am creating a checklist to rate proposals and am using dropdown menus with
values of one through four. I would like to be able to "sum" the responses at the bottom of each section. Is this possible? |
#2
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
If you have another formfield in which you want the sum to be displayed, run
the following macro on exit from each of the dropdowns With ActiveDocument .FormFields("Sum").Result = .FormFields("Dropdown1").Result + ..FormFields("DropDown2").Result _ + .FormFields("Dropdown3").Result + .FormFields("DropDown4").Result End With -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "gh" wrote in message ... I am creating a checklist to rate proposals and am using dropdown menus with values of one through four. I would like to be able to "sum" the responses at the bottom of each section. Is this possible? |
#3
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
If you have another formfield in which you want the sum to be displayed, run
the following macro on exit from each of the dropdowns With ActiveDocument .FormFields("Sum").Result = .FormFields("Dropdown1").Result + ..FormFields("DropDown2").Result _ + .FormFields("Dropdown3").Result + .FormFields("DropDown4").Result End With -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "gh" wrote in message ... I am creating a checklist to rate proposals and am using dropdown menus with values of one through four. I would like to be able to "sum" the responses at the bottom of each section. Is this possible? |
#4
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Given that each dropdown field has a bookmark name, you can check the
calculate on exit check box of each field and use a formula field to add the values of the bookmarks eg { ={ REF Dropdown1} + { REF Dropdown2 } + { REF Dropdown3 }} All brackets are entered with CTRL+F9 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "gh" wrote in message ... I am creating a checklist to rate proposals and am using dropdown menus with values of one through four. I would like to be able to "sum" the responses at the bottom of each section. Is this possible? |
#5
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Given that each dropdown field has a bookmark name, you can check the
calculate on exit check box of each field and use a formula field to add the values of the bookmarks eg { ={ REF Dropdown1} + { REF Dropdown2 } + { REF Dropdown3 }} All brackets are entered with CTRL+F9 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "gh" wrote in message ... I am creating a checklist to rate proposals and am using dropdown menus with values of one through four. I would like to be able to "sum" the responses at the bottom of each section. Is this possible? |
#6
![]() |
|||
|
|||
![]() Quote:
Thank you. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to enter text | Tables | |||
Enter text formula | Tables | |||
How do I enter an if,then,else formula with an embedded sum formul | Tables | |||
How do I enter more than 25 items in a drop down menu box? | Microsoft Word Help | |||
How do I enter a formula in a Word document? | Microsoft Word Help |