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 $$$...
Private Sub UserForm_Initialize()
TextBox3 = Range("P" & ActiveCell.Row)
End Sub
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
Bookmarks