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 - 21 Jul 2006 21:08 GMT
Me.textbox1.value = format(yourformula,"#,##0.00")
for example.
> Hello
>
[quoted text clipped - 11 lines]
>
> V

Signature
Dave Peterson
vgarrow@carletonls.com - 21 Jul 2006 21:17 GMT
> Me.textbox1.value = format(yourformula,"#,##0.00")
>
[quoted text clipped - 15 lines]
> >
> > V
Thank you!!!!
V