Assigning Currency values to checkbox with sum presented as part of paragraph

macropod · #16 07-20-2018, 01:16 PM

It's all in the macro code. Open the document and press Alt-F11 to access the VBA Editor. There you'll see:

Code:

            Case 2 'The 1st row of formfields
              Select Case c  'The columns of formfields
                Case 2: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 9000
                Case 4: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 4500
                Case 6: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 6000
                Case 8: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 3000
              End Select
            Case 3 'The 2nd row of formfields
              Select Case c  'The columns of formfields
                Case 2: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 8000
                Case 4: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 6000
                Case 6: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 4000
                Case 8: If .Range.FormFields(1).CheckBox.Value = True Then i = i + 2000

Simply edit the values to suit (no formatting).

Edwords · #17 07-23-2018, 02:33 AM

Apologies my confusion came as the numbers originally represented by the check boxes were different to what I could see on the code, I've adjusted the values and it works great now, thank you!

However, one of the calculations at the bottom of the page doesnt seem to be working correctly, How can I edit this as I see nothing for this on the code?

Below is an example: the last calculation where subtracting from €100,000, the number subtracted is random and not what has been assigned to any of the boxes.

Quote:

It is estimated that the maximum value of the Fleet Consultancy that your organisation will receive is €16,000. If this amount is likely to increase due to requests for additional work then you will be notified of this, in writing, before work commences.

Therefore you will be eligible to receive consultancy unless you have currently received between €184,000 and €200,000 of State Aid in the last three financial years (or between €92,000 and €100,000 for organisations in the road transport sector).

By signing the declaration overleaf, you are stating that by receiving €16,000 of free consultancy, you will not exceed your State Aid limit.

thanks again for all your help

macropod · #18 07-23-2018, 03:04 AM

My understanding from what you'd previously said was that the amount to deduct from €100,000 is only half what you'd deduct from €200,000. Is that not so?

Edwords · #19 07-23-2018, 03:43 AM

No the amount to be deducted from the €100,000 is the total sum of the services selected which is the same as the the amount deducted from €200,000 not half. Apologies for causing this confusion.

How can I edit this on the form?

macropod · #20 07-23-2018, 05:44 AM

In that case, open the document and unprotect it (Developer|Restrict Editing>Stop Protection). Select the problem field and press Shift-F9. You should see {=100000-{DOCPROPERTY Value }/2 \# ",0"}. Simply delete the '/2', then re-apply the protection (add a password if you want one).

Edwords · #21 07-23-2018, 06:13 AM

PERFECT!!!! thank you very much for you help!!!! Excellent solutions, care and explanations, couldn't have done it without your help, thanks for helping the community!!!!

Edwords · #22 07-23-2018, 07:38 AM

just one question, If i replaced the content control check boxes for formfield check boxes, would i be able to add a formula (containing the same conditions as those for the content control check boxes) into the formfield check boxes and get rid of the macro from the document? and will the document work correctly without the macro?

macropod · #23 07-23-2018, 03:59 PM

The document contains only formfields, including the checkboxes (i.e. no content control checkboxes), so there's nothing to change on that front. And, as I said in post #4:

Quote:

Anything using checkboxes will require a macro.

A formfield solution without a macro is possible possible if you replace all those checkboxes with dropodown formfields for which the user can choose between 'Yes' and 'No', for example. See attached.

Edwords · #24 07-24-2018, 03:29 AM

PERFECTO!!! thanks so much for your help. I can now re work and learn from what youve shown me here

macropod · #25 07-24-2018, 03:50 AM

To see how it's done, unprotect the document, select the entire empty paragraph immediately after the table and press Shift-F9.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning values to form fields and calculating results	AustralianKate	Word Tables	10	05-15-2018 10:53 PM
Can I add part of a paragraph to the document map?	Jennifer Murphy	Word	1	05-28-2017 11:23 PM
Assigning values to formfield checkboxes in a table	mammiano	Word Tables	13	01-12-2015 06:27 AM
Set style for part of paragraph	meileetan	Word	7	06-07-2013 01:09 AM
Assigning Values to content control checkboxes and calculating results	creative cathy	Word Tables	13	10-07-2012 08:52 PM