If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My froms need to include calculations
HI!
I have developed some forms that need to have automatic calculations in parts of the forms. I know how to do it in Excell but the options in Word look limited. How can I include a table with formulas in my form similar to Excel? Any assistance is appreciated. -- Thanks Ali |
#2
|
|||
|
|||
My froms need to include calculations
You can make use of text form fields of the "Calculation" type to perform
calculations in a protected form. To set the type of a text form field: Unprotect the form, and then double-click the form field to display the Text form Field Options dialog box. Under "Type," choose "Calculation." Don't forget to also check the "Calculate on exit" option for the fields. -- Stefan Blom Microsoft Word MVP "Ali" wrote in message ... HI! I have developed some forms that need to have automatic calculations in parts of the forms. I know how to do it in Excell but the options in Word look limited. How can I include a table with formulas in my form similar to Excel? Any assistance is appreciated. -- Thanks Ali |
#3
|
|||
|
|||
My froms need to include calculations
Thanks fo r the info. In Excel all cells have their address that helps
compiling the formula. This is not the case in MS WORD. HJow can I access the formulas when I am in Word? -- Thanks Ali "Stefan Blom" wrote: You can make use of text form fields of the "Calculation" type to perform calculations in a protected form. To set the type of a text form field: Unprotect the form, and then double-click the form field to display the Text form Field Options dialog box. Under "Type," choose "Calculation." Don't forget to also check the "Calculate on exit" option for the fields. -- Stefan Blom Microsoft Word MVP "Ali" wrote in message ... HI! I have developed some forms that need to have automatic calculations in parts of the forms. I know how to do it in Excell but the options in Word look limited. How can I include a table with formulas in my form similar to Excel? Any assistance is appreciated. -- Thanks Ali |
#4
|
|||
|
|||
My froms need to include calculations
You can use cell addresses in Word tables too. If you find it difficult to
keep track of the cell addresses, take a look at http://gregmaxey.mvps.org/Table_Cell_Data.htm. -- Stefan Blom Microsoft Word MVP "Ali" wrote in message ... Thanks fo r the info. In Excel all cells have their address that helps compiling the formula. This is not the case in MS WORD. HJow can I access the formulas when I am in Word? -- Thanks Ali "Stefan Blom" wrote: You can make use of text form fields of the "Calculation" type to perform calculations in a protected form. To set the type of a text form field: Unprotect the form, and then double-click the form field to display the Text form Field Options dialog box. Under "Type," choose "Calculation." Don't forget to also check the "Calculate on exit" option for the fields. -- Stefan Blom Microsoft Word MVP "Ali" wrote in message ... HI! I have developed some forms that need to have automatic calculations in parts of the forms. I know how to do it in Excell but the options in Word look limited. How can I include a table with formulas in my form similar to Excel? Any assistance is appreciated. -- Thanks Ali |
#5
|
|||
|
|||
My froms need to include calculations
If you are using form fields, then each such field has a bookmark name. You
can also calculate the 'boomarks' using a formula field eg {=({Text1} + {Text2})} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Ali wrote: Thanks fo r the info. In Excel all cells have their address that helps compiling the formula. This is not the case in MS WORD. HJow can I access the formulas when I am in Word? You can make use of text form fields of the "Calculation" type to perform calculations in a protected form. To set the type of a text form field: Unprotect the form, and then double-click the form field to display the Text form Field Options dialog box. Under "Type," choose "Calculation." Don't forget to also check the "Calculate on exit" option for the fields. -- Stefan Blom Microsoft Word MVP "Ali" wrote in message ... HI! I have developed some forms that need to have automatic calculations in parts of the forms. I know how to do it in Excell but the options in Word look limited. How can I include a table with formulas in my form similar to Excel? Any assistance is appreciated. -- Thanks Ali |
Thread Tools | |
Display Modes | |
|
|