Possible to have number formatting in TextBox?

[Carlsbergen]

Hi guys.

I have just created a UserForm with some textboxes in it.

In the UserForm_Activate I have written some code that fills in the textboxes
with data from my sheet.

Like so.

Please Login or Register  to view this content.

What I was wondering is if it is possible for the textbox to show the value with
some number formatting. Particularly I want no decimals and I want to use 1000 separator.

Anyone have any ideas?

[phil_b]

TextBox2 = Format(ActiveCell.Offset(0, 23).Value, "#,###")

[Carlsbergen]

TextBox2 = Format(ActiveCell.Offset(0, 23).Value, "#,###")

Sweet! Works great!
Thanks alot!