Decimal places in a userform

[colinharwood]

Hi

When using a textbox on a userform, is it possible to choose the number of decimal places shown from the result of a calculation

Thanks

Colin

 

[royUK]

Without seeing your code something like

me.TextBox1.Value=format(result of calculation,"0.00")

 

[colinharwood]

Hi RoyUK

Thanks for that just what I wanted.

I had been trying with

Application.FixedDecimal = True
Application.FixedDecimalPlaces = 4

but could not get it to work.

Regards

Colin