Need help adding code to Word document to be able to add sums for developer drop down menus

Question

Annual Review Form-Non-Exempt-2.docx

I have created the attached form and would like when a score is selected from the drop down choices for the different hard and soft skill categories that a running total occur shown on page 4. I do not know how to do macro's or write codes. In looking at the online advise from others it is way over my head.... Can anyone help me bring this form to completion PLEASE!

Answer 1

You appear to be wanting to calculate sub-totals for "Hard" and "Soft" skills so you need to identify which dropdowns contribute to each of those categories. For that, you could use the Tag of each dropdown control.

Then, you would need to use the

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)

End Sub

in the ThisDocument module to tally the total of the values of each Content Control by its Tag ID.

See the following and other pages on Greg Maxey's website for more on Content Controls

https://gregmaxey.com/word_tip_pages/content_controls.html

Answer 2

I have read the instructions and have updated my form to put the content control drop downs into tables and then into text boxes. I have attempted to enter the formulas per the instructions. I still am back to needing to add the code but I do not understand the instructions since the answer for the drop down can vary. The explanation just shows basic math- such as you already have a specific number in a field 5 + 5 etc. I do not understand the code.....

Can anyone help me please any further?

Thank you

Beth

Annual Review Form-Non-Exempt-MACRO2.docm

Answer 3

Ok thank you Mr. Robbins. I don't really know what you said but I will watch the link and try and follow the instructions. I appreciate the response, fingers crossed!

Beth

Answer 4

Annual Review Form-Non-Exempt-2.docx

I just realized I had the drop down names partially labeled from my attempts to make this work... I have fixed them all now and wasn't sure if I needed to do a new document link or not so here it is just in case.

Thank you!!!!

Beth