Hi,
I'm building a sort of ratings model for work usbing VBA/Userforms.
I've pretty much finished what I wanted to do calculations wise, except now I want to tidy the userform up a bit.
One of my main pet peeves is when you input numbers into textboxes they are displayed with no format whatsoever.
I know how to format a textbox after making a calculation. (i.e. after you click the command button the textboxes then get formatted)
But how do you format a textbox from the get go, so that as you type into the textbox, the textbox automatically displays the data in your chosen format.
In this example I want my textbox to be displayed as so "$ #,###,###"
I tried entering the following code in the textbox private sub:
TextBox14.Value = Format(TextBox14.Value, "$#,###,##0")
And that did add the dollar sign to the textbox but not the commas, however, what is worse is that now none of my calucations work as the userform doesn't seem to be able to read the value in the textbox anymore.
Any help would be much appreciated.
Thanks,
Bookmarks