How to design form date, currency?

[heroic]

i need creat a form input data to sheet.
I use Dtpicker but date not update day when i use.
How that do?
I want textbox when i in put currency the textbox can show
eg: 100000000 => 100,000,000
hepl me do that
mailto: new_heroicATyahooDOTcomDOTau (new_heroicAt@yahoo.com.au)

[Jacob Hilderbrand]

Try this code to format the text in the textbox.


Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

Me.TextBox1.Value = Format(Me.TextBox1.Value, "#,##0")

End Sub