limit decimal numbers displayed on textbox

[adelvoira]

hello, i have a problem with my textboxes to display decimal numbers with just two (2) decimals no more,
i tried this code:

Private Sub TextBox75_Change()
If IsNumeric(TextBox75.Value) Then
TextBox75.Text = Format(TextBox75, "0.00")
End If
End Sub

and it's not working good as you show in the attached screen caption
https://ibb.co/igUVP6

Thank you

 

[adelvoira]

Yes of course i want the value to look like after the code has executed

 

[FormR]

Yes of course i want the value to look like after the code has executed

Try to answer the questions:

1. Try Mike's code and report back if it works for you?
2. Give an example of the value you are entering in the text box?
3. Tell us what the decimal seperator is for your regional settings? i.e. is it a comma, or a period?
4. For the example from Q2 tell us what the formatted result should look like?

 

[adelvoira]

Yes now i tried the code of #4 mikerickson

​

it's working very very well,

Thanks both of you

​