Textbox Format
 

Hi all,

I have on a userform a textbox where it works out the percentage of the 2
other boxes. But it is not showing in the format I need.

I want it to show as i.e. 56.453
I need it to three decimal places.

Thanks in advance

Greg

Textbox Format
 

As a guess in the first 2 text boxes you have on change code that calculates
the percentage and places that in the 3rd text box. Add your format to the
calculation somethnig like this...

TextBox3.text = format(val(TextBox1.text)/val(TextBox2.text), "0.000")

--
HTH...

Jim Thomlinson


"Greg" wrote:

Hi all,

I have on a userform a textbox where it works out the percentage of the 2
other boxes. But it is not showing in the format I need.

I want it to show as i.e. 56.453
I need it to three decimal places.

Thanks in advance

Greg