Textbox with currency format

  • Thread starter Thread starter C. Thies
  • Start date Start date
C

C. Thies

Hi

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

Thanks

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

End Sub
 
Thanks David! Works nice!

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

End Sub
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform Text box Format to Currency 2
Textbox Formatting Trouble 3
VBA currency or percent format object 1
Simple formatting question 2
Displays numbers as $ on a form 1
pLeAsE hELp! format function in excel visual basic editor 4
Currency formatting (Issue with globalization/localization) 2
Userform with currency format 5

Back
Top