vba textbox format number problem

[paroduso]

hi everyone...
im having trouble formating a number inside 2 textboxes..
i allready tried a lot of codes...searching in google...but none worked for me...
well its textboxes resulting from a multiplication

how can i format the textboxes to 4 decimal places??? i need the result to be 0.2621 in the textbox1 and 0.2482 textbox.2

thank you.

 

[Rick Rothstein]

If you are getting a comma instead of a dot, that is because your decimal point is set to be a comma. I don't do programming for locales other than the U.S., so I cannot test this, but I am thinking simply replacing the comma with a dot after the format has taken place should work. With that said, give this a try...

Private Sub TextBox4_AfterUpdate()
  TextBox5 = Replace(Format(Val(TextBox1) / Val(TextBox2) * Val(TextBox3) * Val(TextBox4), "0.0000"), ",", ".")
End Sub

 

[GWteB]

@Rick Rothstein From The Netherlands: a correct thought (but you already knew that).