View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Zack Barresse Zack Barresse is offline
external usenet poster
 
Posts: 124
Default textbox formatting programmatically

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