MS Excel vba number formatting

Question

Is it possible to set a format to a UserForm textbox so that it automatically changes the numbers from 123456789.123456789 to 123,456,789.123456789.

Private Sub TextBox1_Change()
TextBox1.Value = Format(TextBox1.Value, "#,###.##")
End Sub

I used this, but it round the number to 123,456,789.12 .

Is 123,456,789.123456789 possible within the VBA ? Thanks.

but if you enter the number like this 123456789.12345 it will update to this 123,456,789.123450000 — user2728523
– user2728523, Commented Oct 23, 2014 at 14:43
I have seen how does this work in other applications (maybe not VBA) and I try to create something like that in my code )) — user2728523
– user2728523, Commented Oct 23, 2014 at 14:45

Romain · Accepted Answer · 2014-10-23 13:03:53Z

1

You can add as many # as you want to specify the number of figures after the dot. In your case you can use a format

Format(TextBox1.Value, "#,###.#########")

Should work.

answered Oct 23, 2014 at 13:03

Romain

85910 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Romain Over a year ago

Yes it should cuts the 0s.

user2728523 Over a year ago

it doesn't cut the 0s ((

Romain Over a year ago

It has the proper behavior in excel on my side. I don't see why it would be different in VBA. Try formatting in general first "General" and then reformat again maybe.

Collectives™ on Stack Overflow

MS Excel vba number formatting

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related