View Single Post
 
Old 05-09-2018, 02:49 PM
AustralianKate AustralianKate is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Location: Australia
Posts: 6
AustralianKate is on a distinguished road
Cool Assigning values to form fields and calculating results

Hi All,

Hoping you can help.

My question is similar to https://www.msofficeforums.com/word-...g-results.html in that there are three sets of check boxes in the form and I want to substitute values for each of these, so that when someone selects the check boxes, values are returned and then summed to come up with a total score. That total score then translates back to an overall ranking (e.g. 3-6=Low, 7-10=Medium, 11-15=High or 17-21=Critical).

However, I have a Word dotm form that is set up with form fields (legacy) because I have Mac users as well as PC users (and I understand Active X and Content Controls don't work for Macs).

I assume I cannot use the terrific VBA code that Macropod posted in that thread because it relates to Content Controls... or are there modifications that can be made to that code so that I could use it in my document?

I have attached an excerpt from dotm file (doc) containing the content in question.

Thanks so much for your help.

Kate.
Attached Files
File Type: doc Content Value.doc (43.0 KB, 14 views)

Last edited by macropod; 05-15-2018 at 11:10 PM. Reason: Discussion split to new thread
Reply With Quote