Hi everyone
Is there a way to programmatically format a textbox to use the 1000
Separator(,).

Thx

Hello there,

Not really sure what kind of textbox you are using, so being fairly generic,
use the Format() function, i.e. ...

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

HTH

--
Regards,
Zack Barresse, aka firefytr
MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com"



"malpropio" wrote in message
oups.com...
Hi everyone
Is there a way to programmatically format a textbox to use the 1000
Separator(,).

Thx

Something like this...

Private Sub TextBox1_Change()
TextBox1.Text = Format(TextBox1.Text, "#,##0")
End Sub
--
HTH...

Jim Thomlinson


"malpropio" wrote:

Hi everyone
Is there a way to programmatically format a textbox to use the 1000
Separator(,).

Thx