Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox formatting programmatically
Hi everyone
Is there a way to programmatically format a textbox to use the 1000 Separator(,). Thx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox formatting programmatically
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppress conditional formatting programmatically | Excel Discussion (Misc queries) | |||
Textbox Formatting | Excel Discussion (Misc queries) | |||
Programmatically check cell formatting | Excel Programming | |||
Help with Textbox formatting | Excel Programming | |||
Textbox formatting | Excel Programming |