Wrong result adding values of text boxes in a userform.

Hello

I am not able to understand this.

I have 4 text boxes in a user form where user type numbers. At the end i have another text box(yellow one) that adds these numbers using this code.

Please Login or Register  to view this content.

In another text box(grey one) user types another number.

Then using this code

Please Login or Register  to view this content.

i try to add the values of the two previous text boxes.

I get wrong result when i use decimals numbers and i can not understand what is wrong.

Thanks in advance for any assistance here.

What are you using as a decimal separator when you enter values?

decimals need to go as doubles, so dblValue1=cdbl(textbox1.text) and dblValue2=cdbl(textbox2.text)

then tot will be the sum of the two doubles, tot will need to be a double to.

I'd put in an ISNUMERIC() check on both boxes before running the sub.

We use COmma in Greece MR Norie.

The first video is using nathansav's suggestion like this.

Please Login or Register  to view this content.

http://screencast.com/t/05SPHBl9w

and the other one as i mentioned in my first post

http://screencast.com/t/OY9WKHrlJ

The problem is the comma, if you use a period (.) for the separator the total should calculate correctly.

Try this code to see what the results are when you use Val/Dbl and comma/period, I've also added in an empty string to show what will happen if a textbox is empty.

Please Login or Register  to view this content.

I get these results Mr Norie.

First time i run your code i get 1

click OK>>1,3
click OK>>1,3
click OK>>13
click OK>>0
and clicking OK again, i get an error with highlighting the last line of your code.

Does this work?

Please Login or Register  to view this content.

Of course it's works!!!!

Thank you very much!