I have a table within a form that users will input numbers into. In several
fields, I have a sum calculation that sums the user's input. I know the
fileds will not update automatically (too bad). I would like the users to
either 1) hit a button that updates the fields for them or 2) the fields
update when the document is closed with an "autoclose" macro. Questions: 1)
can I assign a macro that updates the sums to a "floating button or image"
within the document? 2) how do I create an "autoclose" macro? Thank you!

If this is an online form set the properties of the form fields involved in
the calculation to 'calculate on exit'.
Code to update fields and how to employ it can be found at
http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Gail wrote:
I have a table within a form that users will input numbers into. In
several fields, I have a sum calculation that sums the user's input.
I know the fields will not update automatically (too bad). I would
like the users to either 1) hit a button that updates the fields for
them or 2) the fields update when the document is closed with an
"autoclose" macro. Questions: 1) can I assign a macro that updates
the sums to a "floating button or image" within the document? 2) how
do I create an "autoclose" macro? Thank you!