VBA for updating specific fields

Question

Hello,

Let me first say that I understand noting of VBA, so please forgive any misconceptions on my part. I created a quotation-styled form with a few fields containing formulas (i.e. total price, taxes...) in Word. Their value depends on columns like product price, quantity, etc.

I would like to add an ActiveX button to update these specific fields once I have filled in the form (so the document would be protected). I have set bookmark names to them, since I assume the code would need to call them.

Also, I would like the button not to show when printing.

Can this be achieved? What would be the code?

Thank you.

Answer 1

The 'calculate on exit' property should be set on the input fields, not on the calculating fields. Additionally, using formfields to do the calculations is buggy; better to use formula fields for that.

To see how to do a wide range of calculations in Word using formula fields, check out my Microsoft Word Field Maths Tutorial, at:

http://windowssecrets.com/forums/showthread.php/154369-Microsoft-Word-Field-Maths-Tutorial

or

http://www.gmayor.com/downloads.htm#Third_party

Answer 2

I always believed formula and calculating fields were basically the same, I'm glad you cleared that out for me.

Thank you, this actually worked like a charm.

Answer 3

I have activated recalculating on exit, but my main problem is that I have protected the form so that people can only fill it in. Fields with formulas act as unmodifiable ones, so I can't actually tab out of them because they cannot be accessed. That is why I considered the button option.

The fields I use are simple textboxes except those with formulas, both legacy form.

Answer 4

It might be possible, but desireable? Probably not. ActiveX requires macros and is old technology.

If you use legacy form fields in your form and set them to calculate on exit, they will update whenever you tab out of them. Legacy form fields may also be old technology, but not that old.

What kind of fields did you use in your form?