| 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 |
| 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 | |||
Threaded Mode
