View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Adamson[_3_] David Adamson[_3_] is offline
external usenet poster
 
Posts: 40
Default Textbox with currency format

Private Sub StartValue_Change()
'format data
StartValue = Format(StartValue, "$###,##0")

End Sub

"C. Thies" wrote in message
...
Hi

I can't get my textbox to show me formatted numbers ( 1,000,000.75)
How can I do that?

Thanks

Christian