Decimal places in textbox on userform

[Mark]

I am using Excel 97.

I have this userform which picks up data from a
spreadsheet. One of the textboxes gives the result of a
calculation, in some cases is more than 2 decimal places
which is not ideal as it's currency.

Can someone please tell me how to restrict the textbox on
the userform so that only 2 decimal places are displayed?

Thanks


Mark

 

[Guest]

Hi Mark
When you run the calculation you need to out the put a 'Format' following around the last line e.g

X = txtBox
Y = txtBox

txtBoxResult = Format(X * Y ,"#,##

cia
K

----- Mark wrote: ----

I am using Excel 97

I have this userform which picks up data from a
spreadsheet. One of the textboxes gives the result of a
calculation, in some cases is more than 2 decimal places
which is not ideal as it's currency

Can someone please tell me how to restrict the textbox on
the userform so that only 2 decimal places are displayed

Thank


Mar