Sum in TextBox

[Capone]

Hi,

I need your help.
I can't do sum into the Texbox. For example, I have three TextBox

TextBox1 with a Value
TextBox2 with a Value
TexBox3 Sum TextBox1 + TextBox2

So, I can't do this..

Follow attached the draft file.

Thanks in advance.
Regards, Capone.

[gummi]

Please Login or Register  to view this content.

There you go

[davesexcel]

Why not

Please Login or Register  to view this content.

[royUK]

You are trying to summ the totals with the afterupdate event of each textbox. You will get an error if one of the textboxes is empty or does not contain a number.

[royUK]

Why not

Please Login or Register  to view this content.

Dave the entry in the textboxes is by default a String so you need to use CDbl or CCur change the strings to values. Your code will just concatenate the entries, not add them up

[Capone]

All,


Your Code:

Please Login or Register  to view this content.

This code not run and de sum TextBox1 (when I input USD 2,50) + TextBox2 (when I input USD 3,00) produce in TextBox3 USD 575,00



somebody has another ideia please?

Thanks in advance!

Pietro.

[gummi]

It works juts fine for me.

Use . instead or , or change the formatting I guess.

[Capone]

For me no...independent if you use "." or ","