Limiting decimals text box

[D.S.]

In my userform text boxes, I'm returning worksheet values of cells that are
custom formatted to 3 decimal places.

I'm returning to separate text boxes in the userform, the 'high', 'low', and
'average' worksheet functions of the cells.

How can I limit the text boxes to only show 3 decimal places?

D.S.

Donald [email protected]

 

[Bill Barclift]

Use the round method with the 'high', 'low', or 'average' as the first
argument, like:

txtMyTextBox.Text = Round(dblHigh, 3)


Bill Barclift

 

[D.S.]

Thanks Bill! That was exactly what I was looking for. Works great.

D.S.

Donald [email protected]

 

[D.S.]

Thanks Bill! That was exactly what I was looking for, works great.

D.S.

DonaldDonald [email protected]