Hi i'm having a trouble with this i got 3 textbox and i format it to
Textbox1.Text = Format(Textbox1.Text, "Standard")
Textbox2.Text = Format(Textbox2.Text, "Standard")
Textbox3.Text = Format(Textbox3.Text, "Standard")
which give something like this
1,230.00
2,500.00
1,245.00
and when i add itTextbox4.text = Val(Textbox1.Text) + Val(Textbox2.Text) + Val(Textbox3.Text)
the result is this
4.00
how can i sum it when the format is in "standard" or "percent"?