(Msg. 1) Posted: Sun Jun 29, 2008 1:16 pm
Post subject: calculating totals in forms Archived from groups: microsoft>public>word>vba>userforms (more info?)
Hi'
I am a complete newbie to forms in microsoft word (1st ever yesterday) I
have created a from with a choice of quantities in one drop-down list and of
prices in another list (each has its own column in a table in a word
document). I have a sub-total column (to the right of these columns) where I
would like the sub-total to be calculated and shown (i.e. quantity x price),
and and total which adds the list of sub-totals and displays this total at
the bottom of that column.
(Msg. 2) Posted: Mon Jun 30, 2008 3:03 am
Post subject: Re: calculating totals in forms [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
To do that without having to use a macro, assign the bookmark name of
Quantity1 to the quantity dropdown and Price1 to the price dropdown and
check the Calculate on Exit box for each of those formfields. Then where
you want the product of the two to appear, insert the following field
construction
{ = { REF Quantity1 } * { REF Price1 } }
You will need to give a different bookmark name to each pair of quantity and
price dropdown formfields, e.g. Quantity2 and Price2, Quantity3 and Price3
Where you want the Total to appear, insert
{ = SUM(ABOVE) }
You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle of their display.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Joe Fitzpatrick" <AXRG25 DeleteThis @dsl.pipex.com> wrote in message
news:WpudnQzTBc6V8vrVRVnyjwA@pipex.net...
> Hi'
> I am a complete newbie to forms in microsoft word (1st ever yesterday) I
> have created a from with a choice of quantities in one drop-down list and
> of prices in another list (each has its own column in a table in a word
> document). I have a sub-total column (to the right of these columns) where
> I would like the sub-total to be calculated and shown (i.e. quantity x
> price), and and total which adds the list of sub-totals and displays this
> total at the bottom of that column.
>
> I have no knowledge of macros or vba.
>
> Any suggestions/solutions?
> Thanks in advance
> Joe
>
(Msg. 3) Posted: Tue Jul 01, 2008 4:57 pm
Post subject: Re: calculating totals in forms [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi and thanks for the information.
It seems a bit complex given 4 sizes x 4 prices meaning a 16 matrix of
possible solutions. I would have thought that, given that this is such a
common requirement, that code/macros were readily available and I was really
looking towards these for a solution together with advice as to how to do
it.
Thanks again
Joe
"Doug Robbins - Word MVP" <dkr.TakeThisOut@REMOVECAPSmvps.org> wrote in message
news:Ogp07Dj2IHA.2384@TK2MSFTNGP04.phx.gbl...
> To do that without having to use a macro, assign the bookmark name of
> Quantity1 to the quantity dropdown and Price1 to the price dropdown and
> check the Calculate on Exit box for each of those formfields. Then where
> you want the product of the two to appear, insert the following field
> construction
>
> { = { REF Quantity1 } * { REF Price1 } }
>
> You will need to give a different bookmark name to each pair of quantity
> and price dropdown formfields, e.g. Quantity2 and Price2, Quantity3 and
> Price3
>
> Where you want the Total to appear, insert
>
> { = SUM(ABOVE) }
>
> You must use Ctrl+F9 to insert each pair of field delimiters { } and
> Alt+F9 to toggle of their display.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "Joe Fitzpatrick" <AXRG25.TakeThisOut@dsl.pipex.com> wrote in message
> news:WpudnQzTBc6V8vrVRVnyjwA@pipex.net...
>> Hi'
>> I am a complete newbie to forms in microsoft word (1st ever yesterday) I
>> have created a from with a choice of quantities in one drop-down list and
>> of prices in another list (each has its own column in a table in a word
>> document). I have a sub-total column (to the right of these columns)
>> where I would like the sub-total to be calculated and shown (i.e.
>> quantity x price), and and total which adds the list of sub-totals and
>> displays this total at the bottom of that column.
>>
>> I have no knowledge of macros or vba.
>>
>> Any suggestions/solutions?
>> Thanks in advance
>> Joe
>>
>
>
(Msg. 4) Posted: Wed Jul 02, 2008 3:05 am
Post subject: Re: calculating totals in forms [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
What's so complex? The formula calculates each of those 16 possible
results.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Joe Fitzpatrick" <AXRG25.TakeThisOut@dsl.pipex.com> wrote in message
news:ZvCdnb9EoelP2PfVnZ2dnUVZ8u-dnZ2d@pipex.net...
> Hi and thanks for the information.
>
> It seems a bit complex given 4 sizes x 4 prices meaning a 16 matrix of
> possible solutions. I would have thought that, given that this is such a
> common requirement, that code/macros were readily available and I was
> really looking towards these for a solution together with advice as to how
> to do it.
>
> Thanks again
> Joe
>
>
> "Doug Robbins - Word MVP" <dkr.TakeThisOut@REMOVECAPSmvps.org> wrote in message
> news:Ogp07Dj2IHA.2384@TK2MSFTNGP04.phx.gbl...
>> To do that without having to use a macro, assign the bookmark name of
>> Quantity1 to the quantity dropdown and Price1 to the price dropdown and
>> check the Calculate on Exit box for each of those formfields. Then
>> where you want the product of the two to appear, insert the following
>> field construction
>>
>> { = { REF Quantity1 } * { REF Price1 } }
>>
>> You will need to give a different bookmark name to each pair of quantity
>> and price dropdown formfields, e.g. Quantity2 and Price2, Quantity3 and
>> Price3
>>
>> Where you want the Total to appear, insert
>>
>> { = SUM(ABOVE) }
>>
>> You must use Ctrl+F9 to insert each pair of field delimiters { } and
>> Alt+F9 to toggle of their display.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "Joe Fitzpatrick" <AXRG25.TakeThisOut@dsl.pipex.com> wrote in message
>> news:WpudnQzTBc6V8vrVRVnyjwA@pipex.net...
>>> Hi'
>>> I am a complete newbie to forms in microsoft word (1st ever yesterday) I
>>> have created a from with a choice of quantities in one drop-down list
>>> and of prices in another list (each has its own column in a table in a
>>> word document). I have a sub-total column (to the right of these
>>> columns) where I would like the sub-total to be calculated and shown
>>> (i.e. quantity x price), and and total which adds the list of sub-totals
>>> and displays this total at the bottom of that column.
>>>
>>> I have no knowledge of macros or vba.
>>>
>>> Any suggestions/solutions?
>>> Thanks in advance
>>> Joe
>>>
>>
>>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum