View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Format Textbox w/ $ sign

Private Sub TextBox10_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox10.Value = Format(TextBox10.Value, "$ #,##.00")
End Sub


"jeff" wrote:

I guess I'm not going to find this out with a search. Seems it would
be simple.

All I want is for TextBox10 to have a $ sign in it. I'll even let the
user supply the decimal.
I've tried variations of this in the initialization sub:
TextBox10 = Format(c, "###,###.##")
I've tried it w/ the C, w/o the C. With $ signs. Anything I could
think of. Any help would be appreciated.
Thanks
j.o.