ExcelBanter - Textbox with currency format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Textbox with currency format (https://www.excelbanter.com/excel-programming/303083-textbox-currency-format.html)

C. Thies

Textbox with currency format

Hi

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

Thanks

Christian

David Adamson[_3_]

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

C. Thies

Textbox with currency format

Thanks David! Works nice!

"David Adamson" escribió en el mensaje
...
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

All times are GMT +1. The time now is 02:57 PM.