How do I add checkboxes

[loomie]

I am trying to find out how to add up check boxes based on the rating
selected. I have 7 items which require a rating from 1-5. I am trying to have
these add up at the bottom for all 7 items based on each rating selected.
Does anyone know how to do this? I found that I can do this in excel in a
different way by inserting a drop down field with the ratings per each item
and have a formula to total each one, but I don't know how to replicate this
in word. Any help would be greatly appreciated!!!!!

 

[Jay Freedman]

I am trying to find out how to add up check boxes based on the rating
selected. I have 7 items which require a rating from 1-5. I am trying to have
these add up at the bottom for all 7 items based on each rating selected.
Does anyone know how to do this? I found that I can do this in excel in a
different way by inserting a drop down field with the ratings per each item
and have a formula to total each one, but I don't know how to replicate this
in word. Any help would be greatly appreciated!!!!!

You can do the dropdown thing in Word, too, and you don't need any macro to do
it.

Assuming you're already using a protected form with form fields, insert seven
dropdowns. Each one, in its Properties page, should have the five ratings as the
items in the dropdown list (just enter the numbers 1 through 5, clicking the Add
button for each one). Each dropdown should also have a check mark in both the
"Dropdown enabled" and the "Calculate on exit" boxes. Each dropdown should have
a unique name in the Bookmark box -- for example, Q1 for the first one, Q2 for
the second one, and so on up to Q7.

At the place where you want the total, build a formula field. Start by pressing
Ctrl+F9 to insert a pair of field braces, and type an equal sign between them.
Then press Ctrl+F9 again, so you have a field inside the field, like this:

{ = { } }

Type the name of the first dropdown into the inside field, for example

{ = {Q1} }

Now move between the two closing braces, type a plus sign, and press Ctrl+F9
again:

{ = {Q1} + { } }

Put in the name of the second field, for example

{ = {Q1} + {Q2} }

Continue adding more plus signs and inner fields until you've listed all seven
dropdowns. Then press F9 to update the field. It should show the sum of the
dropdown values.

Finally, lock the form, and try changing the values of various dropdowns. Every
time you change one and then move to another form field, the total field should
automatically update.

 

[macropod]

Hi Jay,

I'd suggest not using Q1, Q2 etc. Word is liable to confuse this with cell references, especially if the formula is in a table.
Perhaps Chk1, Chk2 etc.

 

[Jay Freedman]

Good point. I don't often use cell references in Word, so it didn't occur to me.

Hi Jay,

I'd suggest not using Q1, Q2 etc. Word is liable to confuse this with cell references, especially if the formula is in a table.
Perhaps Chk1, Chk2 etc.

--
Cheers
macropod
[MVP - Microsoft Word]

You can do the dropdown thing in Word, too, and you don't need any macro to do
it.

Assuming you're already using a protected form with form fields, insert seven
dropdowns. Each one, in its Properties page, should have the five ratings as the
items in the dropdown list (just enter the numbers 1 through 5, clicking the Add
button for each one). Each dropdown should also have a check mark in both the
"Dropdown enabled" and the "Calculate on exit" boxes. Each dropdown should have
a unique name in the Bookmark box -- for example, Q1 for the first one, Q2 for
the second one, and so on up to Q7.

At the place where you want the total, build a formula field. Start by pressing
Ctrl+F9 to insert a pair of field braces, and type an equal sign between them.
Then press Ctrl+F9 again, so you have a field inside the field, like this:

{ = { } }

Type the name of the first dropdown into the inside field, for example

{ = {Q1} }

Now move between the two closing braces, type a plus sign, and press Ctrl+F9
again:

{ = {Q1} + { } }

Put in the name of the second field, for example

{ = {Q1} + {Q2} }

Continue adding more plus signs and inner fields until you've listed all seven
dropdowns. Then press F9 to update the field. It should show the sum of the
dropdown values.

Finally, lock the form, and try changing the values of various dropdowns. Every
time you change one and then move to another form field, the total field should
automatically update.


--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.