Format TextBox in UserForm

[vgarrow]

Hello

I have a userform which contains textboxes with calculations. For
example, I have a statement that requires the user to input data to be
used to calculate inventory turns. Once the data is entered, a formula
will calculate the number of inventory turns and will display in a
separate textbox. Is there a way to format the textbox so the formula
is in "comma" style? Currently, the calculation returns 5 or 6 places
to the left of the decimal. Is there a better control other than a
"textbox" to perform this calculation or is there a way to format the
textbox to show only 2 places after the decimal?

Thank you

V

 

[Dave Peterson]

Me.textbox1.value = format(yourformula,"#,##0.00")

for example.

 

[vgarrow]

Me.textbox1.value = format(yourformula,"#,##0.00")

for example.

Thank you!!!!

V