Format a userform field

[patupatu]

How can give format to a form field to represent a numeric valur with thousand separators and decimal point

Thank you

 

[Jaafar Tribak]

How can give format to a form field to represent a numeric valur with thousand separators and decimal point

Thank you

Maybe this :

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

    TextBox1 = Format(CDbl(TextBox1), "##,##0.00")

End Sub