View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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