Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Button Macro for Caclulating in Word Tables
Can anyone can point me to an example of a macro that you would assign to a
command button in Word 2007 that calculates a result based on values from multiple cells in one table and puts that result in another cell in a separate table? I've been told that I cannot link Excel spreadsheets for this application; it has to be stand-alone Word. So, I either have to do this in Word or not do it. Any help would be appreciated, Thanks. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Button Macro for Caclulating in Word Tables
Hi Ned,
To see how to reference cells in another table in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Reference Table Cells From Outside The Table' To force a re-calc in the linked table, simply select the cell(s) concerned and press F9. Alternatively, you could insert a MACROBUTTON field onto the linked table, coded as {MACROBUTTON CalcTable Update} and use the following macro: Sub CalcTable() Dim oFld As Field For Each oFld In Selection.Tables(1).Range.Fields oFld.Update Next End Sub Note: The field brace pairs (ie '{ }') for the MACROBUTTON field are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Similar macro code could be used for a command button. -- Cheers macropod [MVP - Microsoft Word] "Ned23" wrote in message ... Can anyone can point me to an example of a macro that you would assign to a command button in Word 2007 that calculates a result based on values from multiple cells in one table and puts that result in another cell in a separate table? I've been told that I cannot link Excel spreadsheets for this application; it has to be stand-alone Word. So, I either have to do this in Word or not do it. Any help would be appreciated, Thanks. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Button Macro for Caclulating in Word Tables
Thanks macropod. I've downloaded your file and am studying it and have built a file with some macros in it and am fiddling around with it. To anyone else out there, I'd like to say that I'm more of a visual learner, so if anyone has an example of the process in action, I'd appreciate it. By that I mean an example where someone actually has a Word 2007 file with a couple of tables in it and a macro to go with it that calcualtes some results when you press a command button. I think I could look at that and very quickly adapt it to my forms. Thanks, Ned. "macropod" wrote: Hi Ned, To see how to reference cells in another table in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Reference Table Cells From Outside The Table' To force a re-calc in the linked table, simply select the cell(s) concerned and press F9. Alternatively, you could insert a MACROBUTTON field onto the linked table, coded as {MACROBUTTON CalcTable Update} and use the following macro: Sub CalcTable() Dim oFld As Field For Each oFld In Selection.Tables(1).Range.Fields oFld.Update Next End Sub Note: The field brace pairs (ie '{ }') for the MACROBUTTON field are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Similar macro code could be used for a command button. -- Cheers macropod [MVP - Microsoft Word] "Ned23" wrote in message ... Can anyone can point me to an example of a macro that you would assign to a command button in Word 2007 that calculates a result based on values from multiple cells in one table and puts that result in another cell in a separate table? I've been told that I cannot link Excel spreadsheets for this application; it has to be stand-alone Word. So, I either have to do this in Word or not do it. Any help would be appreciated, Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Design own button for macro in Word 2007 | Microsoft Word Help | |||
Word 2007 macro button icons | Microsoft Word Help | |||
macro runs from keyboard, but not from macro button-why? | Microsoft Word Help | |||
insert macro button on word document | New Users | |||
How do I assign a macro to a toolbar/button using Word 2003? | Microsoft Word Help |