Format of a TextBox in a userform
Try,
Textbox1.Text = Format(the_amount,"# ### ##0$")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"MD" wrote in message
...
Good day,
I have a userform that has a TextBox. In this TextBox, I want to enter
dollar amounts so that it looks like this: 1 234 567 $. Right now I get
this: 1234567.
regards,
MD
|