Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal Places in TextBox
Hi,
I need to set a certain number of decimal places in a TextBox. Is there a way to do this with code or in a property? The TextBox is on a Form. The TextBox is used to display a number Value. It is not linked to anything outside the form, IE: cells on a worksheet etc. Thank you, Amy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal Places in TextBox
Amy, you could do something like this:
TextBox.Text = VBA.FormatNumber(Value,2) where, in this example, 2 represents the number of decimal places that will be shown in the text box. "AMY Z." wrote: Hi, I need to set a certain number of decimal places in a TextBox. Is there a way to do this with code or in a property? The TextBox is on a Form. The TextBox is used to display a number Value. It is not linked to anything outside the form, IE: cells on a worksheet etc. Thank you, Amy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal Places in TextBox
Hi Paul,
Thank you for taking time to answer my question. It doesn't work. It doesn't show an error, but won't display anything. Do you know where I should enter the code? Do I need to declare too? Using Dim? This is what I have: Private Sub TextBox3_Change() TextBox3.Text =VBA.FormatNumber(Value,2) I'm just learning how to program. Thanks again if you come back to this post, Amy "Paul Mathews" wrote: Amy, you could do something like this: TextBox.Text = VBA.FormatNumber(Value,2) where, in this example, 2 represents the number of decimal places that will be shown in the text box. "AMY Z." wrote: Hi, I need to set a certain number of decimal places in a TextBox. Is there a way to do this with code or in a property? The TextBox is on a Form. The TextBox is used to display a number Value. It is not linked to anything outside the form, IE: cells on a worksheet etc. Thank you, Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal places | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal places | Excel Programming | |||
UserForm TextBox Decimal Places | Excel Programming |