I'm not 100% sure which forum this would be under, but I'm trying to create a template/form. In the form there are four different options to choose from, lets say A, B, C and D. Option A=1 B=2 C=3 and D=4. If the user marks the box in option A, I want the number 1 to come up in the total column of the form. Same thing for B would be 2, C would be 3 and D would be 4. Is there a way to get this in the form? If not, what about using excel? I'm trying to streamline an evaluation form at work and I have to get it done sooner than later.



Any help you can provide would be greatly appreciated.

-schiesa

See attached. The document uses a dropdown formfield, with its 'calculate on exit' property set for the ABCD selection and some formula fields for the calculation.

The document uses formfields, which requires the document to have forms protection. This also prevents users making unauthorised changed. Formfields, together with the doc format, are compatible with all Word versions.

To see how it all works, unprotect the document, then click on the dropdown formfield, right-click and choose 'properties'. Then to see how the calculations work, press Alt-F9 to toggle the field code display.

Attached Files

AutoPopulate.doc (36.5 KB, 19 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]