#1
|
|||
|
|||
Calculations
Is there anyway to do calculations in a table in "real time"? The calculations that I was able to do already had values in the cells that are used in my calculations. What I want to do is to enter data via fields of a form and do the calculations after the values are entered.
|
#2
|
||||
|
||||
If you use formfields for the data entry and formula fields for the calculations, setting the formfields' 'calculate on exit' property and applying forms protection to the document can achieve such a result. A forum search will turn up numerous examples.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I tried that but it did not work. I wonder if I have to create a template and not a doc file to have it work properly (I have the form protected but that should not affect anything). The formulas only worked if data was already there when I created the formulas not if I enter the data on the fly.
|
#4
|
||||
|
||||
That's hardly a problem description anyone can work with. Field calculations in Word work well; indeed, I've written tutorials and contributed to books on the subject.
To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at: http://windowssecrets.com/forums/sho...Maths-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party To see how to do just about everything you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: http://windowssecrets.com/forums/sho...ation-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks, I will take a look at your links.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Errors in financial calculations | Richard121 | Excel | 6 | 05-07-2015 12:52 PM |
Tiered Fee Calculations | lynchbro | Excel | 5 | 07-17-2014 11:01 AM |
Table Calculations, VBA | SuzeG | Word VBA | 7 | 12-15-2013 07:12 PM |
How to do Calculations In a Text Box? | SteveF | Word | 4 | 09-27-2013 08:34 AM |
Can I do calculations with times? | cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |