Userform textbox format

[colinharwood]

Hi

I have a userform with a text box that displays a calculated value, is there any way to limit the number of decimal places displayed,ideally I would like to only display 3 decimal places

Thanks

 

[Norie]

Use Format to return the calculated value with the required no of decimal places.

 

[colinharwood]

Sorry if I did not make myself clear, but the calculated value is diplayed on the useform, not entered into a sheet cell.

I cannot see a format option for a textbox

Thanks

 

[Norie]

I wasn't referring to an option/property of the textbox, I was referrring to the VBA function Format.