Limiting decimals text box
 

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

Limiting decimals text box
 

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

txtMyTextBox.Text = Round(dblHigh, 3)


Bill Barclift


"D.S." wrote in message
...
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

Limiting decimals text box
 

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

D.S.

Donald
"Bill Barclift" wrote in message
news:Jd3kb.14793$iq3.2438@okepread01...
Use the round method with the 'high', 'low', or 'average' as the first
argument, like:

txtMyTextBox.Text = Round(dblHigh, 3)


Bill Barclift


"D.S." wrote in message
...
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

Limiting decimals text box
 

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

D.S.

DonaldDonald
"Bill Barclift" wrote in message
news:Jd3kb.14793$iq3.2438@okepread01...
Use the round method with the 'high', 'low', or 'average' as the first
argument, like:

txtMyTextBox.Text = Round(dblHigh, 3)


Bill Barclift


"D.S." wrote in message
...
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