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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|