[GH]

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?

[Doug Robbins - Word MVP]

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?

[Doug Robbins - Word MVP]

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?

[Graham Mayor]

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?

[Graham Mayor]

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?

[mlwarthen]

Originally Posted by Graham Mayor

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

How exactly are brackets entered with CTRL+F9? Holding the keys down at the same time the { is entered?
Thank you.