formatting text box if users input numbers

[Marco]

I created a user form that collects data.
There is a text box in which users can enter in text or numbers.
If the user enters in numbers is there VBA code that will make the entered
numbers show up in a specific format Ie: #,##0.00

Thanks

 

[Jonathan West]

I created a user form that collects data.
There is a text box in which users can enter in text or numbers.
If the user enters in numbers is there VBA code that will make the
entered
numbers show up in a specific format Ie: #,##0.00

You can use the Format function to format a string in a specific way. You
could call that function from the Exit event of the textbox, so that the
contents are reformatted when the user moves elsewhere.

 

[Marco]

Great idea...it worked perfectly.
Thanks

You can use the Format function to format a string in a specific way. You
could call that function from the Exit event of the textbox, so that the
contents are reformatted when the user moves elsewhere.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup