WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

calculating totals in forms

 
   Home -> Office -> User Forms RSS
Next:  User Forms: Detecting or reading the name of a textbox  
Author Message
Joe Fitzpatrick

External


Since: Jun 29, 2008
Posts: 2



(Msg. 1) Posted: Sun Jun 29, 2008 1:16 pm
Post subject: calculating totals in forms Add to elertz
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.

I have no knowledge of macros or vba.

Any suggestions/solutions?
Thanks in advance
Joe
Back to top
Login to vote
Doug Robbins - Word MVP

External


Since: Jul 14, 2006
Posts: 4784



(Msg. 2) Posted: Mon Jun 30, 2008 3:03 am
Post subject: Re: calculating totals in forms Add to elertz [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
>
Back to top
Login to vote
Joe Fitzpatrick

External


Since: Jun 29, 2008
Posts: 2



(Msg. 3) Posted: Tue Jul 01, 2008 4:57 pm
Post subject: Re: calculating totals in forms Add to elertz [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
>>
>
>
Back to top
Login to vote
Doug Robbins - Word MVP

External


Since: Jul 14, 2006
Posts: 4784



(Msg. 4) Posted: Wed Jul 02, 2008 3:05 am
Post subject: Re: calculating totals in forms Add to elertz [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 RemoveThis @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 RemoveThis @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 RemoveThis @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
>>>
>>
>>
>
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> User Forms 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET