In the TextBox_Change event add following code

TextBox1.Text = Replace(Format(TextBox1.Text, "#,##0 \$"), ",", " ")\

Sharad

"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