Problems with viewing values in simple calculations

[jazz_bass]

Hi,

Could anyone help with the following query?

i created a userform that calclulates the differences of "before" and "after" both for individual values and total. Why do I get "1" in "Total before" even though there is 1,2 in the first value of before?

______before___after____difference
1_______1,2______2_______ 0.8
2________0______0_________0
Total_____1______2________0.8

Total1 is defined by
TextBoxTotal.Value = Val(TextBox1before.Value) + Val(TextBox2before.Value)

Thanks!

[watersev]

hi jazz_bass, try replace coma with a dot in "1,2" and you should get what you want

[jazz_bass]

already tried that.
when i use coma i get runtime error 13 - type mismatch.

[watersev]

post your workbook with the userform and coding