UserForm - TextBox = Format("yyyy/mm/dd")

Thread should be: UserForm - TextBox = Format(Me.TextBox3, "$#,##0.00")

Good day,
Looking for help on the following:

I have a UserForm that when Activated it will automatically add in textbox3 the amount from my Active Cell the amount $$$...

Please Login or Register  to view this content.

Information in Range("P" & ActiveCell.Row) let’s say is $50,000.00, when I active the UserForm adds the info but not the same format. 50000 will be added to TextBox3.

Is there a way to add the same “exactly” same format, so if $50,000.00 is inserted in my cell that when I open my Userform it will be the same?

Thank you

Hello Excelnou,

If you want the TextBox to reflect the cell's contents as displayed then use the Text property of the cell. This will return the cell's contents as a string. No need to worry about formatting.

Please Login or Register  to view this content.