Limit Characters Shown in a text box

  • Thread starter Thread starter jamie
  • Start date Start date
J

jamie

Ok...any brainiacs out there!?

I have a userform in excel...
Each Text Box shows a value that is calculated elsewhere within the
spreadsheet...
with the following VB: Me.TxtNamOEM.Text = Range("D15").Value

The value is a calculated value (again taken from the spreadsheet -
the userform acts as a convenient viewer only!).

But the number shows 58.6666666667 (for example) and I want it to only
show 58.67...I have tried changing the Max length property of the text
box (TxtNamOEM) but this doesn't work.

Can anyone help? Thanks in advance

Jamie
 
Ok...any brainiacs out there!?

I have a userform in excel...
Each Text Box shows a value that is calculated elsewhere within the
spreadsheet...
 with the following VB: Me.TxtNamOEM.Text = Range("D15").Value

The value is a calculated value (again taken from the spreadsheet -
the userform acts as a convenient viewer only!).

But the number shows 58.6666666667 (for example) and I want it to only
show 58.67...I have tried changing the Max length property of the text
box (TxtNamOEM) but this doesn't work.

Can anyone help? Thanks in advance

Jamie
Click to expand...

Try changing "Me.TxtNamOEM.Text = Range("D15").Value " to
"Me.TxtNamOEM.Text = Format(Range("D15").Value, "0.00")"

Cheers
 

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

Text box value to userform 2
Tab character in a Text Box 1
Can I put a Formula into an Excel User Form? 1
Showing a calculation in a userform Textbox 3
Userform 1
list box controls - text property 2
Text Box Control Source 6
Formatting in Text Boxes 6

Back
Top