Textbox Format

G

Greg

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
 
G

Guest

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple formatting question 2
Percenatge Format in TextBox 5
Combobox selection 1
Firing Event in another user form 1
Userform textbox string to header causes unwanted double spacing 4
userform textbox returns changeable date 4
Access Dateadd function question.. 0
TEXTBOX COPY AND FORMAT !! 3

Top