Textbox number formatting

[dave8]

How to format a Textbox such that if I enter, 1000, it will display 1,000? And if I enter 10000, it will display 10,000. Or, 100000, it will display 100,000.

 

[Sahak]

Try this

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    TextBox1.Value = Format(TextBox1.Value, "#,###")
End Sub

 

[dave8]

Thank you very much! It works beautifully.