Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I add multiple table calculations in word?
|
#2
|
|||
|
|||
This space is for you to adequately describe what it is that you want to do.
-- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. stheo wrote: |
#3
|
|||
|
|||
OK, Now that I have read some of these....
I would like to 1) know how this bookmarking works without causing errors in the formula. 2) Also I would like to know how to show the calculations to the user as he fills out the form. -- Sheila "Greg Maxey" wrote: This space is for you to adequately describe what it is that you want to do. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. stheo wrote: |
#4
|
|||
|
|||
I'll take a stab in the dark...
'tRows = Total number of rows in table. tRows = Monthly.Tables(5).Rows.Count 'Set range to desired cell Set CurCell = Monthly.Tables(5).Cell(tRows, 3) 'Insert formula CurCell.Formula Formula:="=SUM(above) \# ###0.0" |
#5
|
|||
|
|||
Hi Sheila,
You mention the filling in of a form, so I'll assume you're using a formfield. In that case, all you need to do to set a bookmark for the formfield and to make any dependent calculations update automatically is to: 1) Right-click on the formfield and select 'properties'; 2) Check the 'calculate on exit' box; and 3) If you need to use the formfield's value outside a table, give it an appropriate bookmark name instead of the default Word one (typically Text1, Text2 etc). Then, create the formula field that does the calculations. Once that's done, simply protect the document for forms. from then on, entering a value into the formfield then tabbing out of it will update the calculation. Cheers PS: For more information on doing maths in Word, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 (url all one line) "STheo" wrote in message ... OK, Now that I have read some of these.... I would like to 1) know how this bookmarking works without causing errors in the formula. 2) Also I would like to know how to show the calculations to the user as he fills out the form. -- Sheila "Greg Maxey" wrote: This space is for you to adequately describe what it is that you want to do. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. stheo wrote: |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The WordPerfect "Reveal Codes" method is so much easier to use. | Microsoft Word Help | |||
Making Word do something that Wordperfect can do | New Users | |||
creating forms | Microsoft Word Help | |||
Boiletplates from Word Perfect | Microsoft Word Help | |||
Converted document from WordPerfect. New footnotes are not being. | Microsoft Word Help |