Summing numeric textfields

External Since: Jul 28, 2008 Posts: 1

I have six numeric textfields on a protected form. Numbers are entered into
these five fields in sequence and not all of the textfields will have a
content.
I have tried to write a macro that will provide the sum of the first five
textfields in the sixth field without success.
Please is there someone who can resolve this problem for me?

External Since: Jul 14, 2006 Posts: 4210

You do not need a macro to do that. Assuming that the formfields have the
bookmarks names of Text1, Text2, Text3, Text4, Text5 and Text6, in the
properties dialog for Text1, Text2, Text3, Text4 and Text5 check the box for
Calculate on Exit and in the dialog for Text 6, change the type to
Calculation and enter the following formula in the Expression control

= Text1 + Text2 + Text3 + Text4 + Text5

Protect the document for forms and you're on your way.

--
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

"TeeKAus" <TeeKAus.DeleteThis@discussions.microsoft.com> wrote in message
news:DDC59B67-20D1-47B1-91AF-2582E03B79FA@microsoft.com...
>I have six numeric textfields on a protected form. Numbers are entered into
> these five fields in sequence and not all of the textfields will have a
> content.
> I have tried to write a macro that will provide the sum of the first five
> textfields in the sixth field without success.
> Please is there someone who can resolve this problem for me?