Solved: Format Number in VBA

[clhare]

I am working on a userform in Word and have been asked to set up a textbox to format the number entered without dollar sign and without decimal places--only thousand separator. Is there a way to do that?

:think: Thanks for your help!

[clhare]

Turned out to be really simple. I put the following code behind the text box. If a "$" is entered, it'll just disappear when I start entering a number. Decimal points can't even be entered. Perfect!


txtAmount1.Value = Format(txtAmount1, "#,##0")

[clhare]

Forgot to mention that I used the "Change" event. Doesn't work if I use the "Click" event.

[lucas]

Glad you got this worked out. Thanks for posting your solution for others. Please mark your thread solved using the thread tools at the top of the page.