| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit Characters Shown in a text box
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit Characters Shown in a text box
On 9 Sep, 11:38, wrote:
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 Try changing "Me.TxtNamOEM.Text = Range("D15").Value " to "Me.TxtNamOEM.Text = Format(Range("D15").Value, "0.00")" Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit to 5 characters... | Excel Worksheet Functions | |||
| Counting characters in text cell to find 255 limit | Excel Discussion (Misc queries) | |||
| Limit characters | Excel Programming | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Limit characters in a word/text box in excel | Excel Programming | |||
Hybrid Mode
