Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Decimal Places in TextBox
2 views
Skip to first unread message
AMY Z.
Oct 14, 2006, 3:50:02 PM10/14/06
to
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.
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
Paul Mathews
Oct 14, 2006, 4:58:02 PM10/14/06
to
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.
Oct 16, 2006, 10:44:02 AM10/16/06
to
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)
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
0 new messages