Format Textbox Value 
Author Message
 Format Textbox Value

Hello anybody, Help

How to format a textbox value resulting from a simple multiplication on a
userform.

Say: format as user defined "##,##0.00" and also as Named numeric format
Currency

Example:

Private Sub CommandButton3_Click()
    Me.Textbox3.Value = Me.TextBox1.Value * Me.TextBox2.Value
End Sub

Thank you'

GH



Thu, 18 Sep 2003 22:17:11 GMT  
 Format Textbox Value
Hi Glen,

Quote:
> How to format a textbox value resulting from a simple multiplication on a
> userform.

> Say: format as user defined "##,##0.00" and also as Named numeric format
> Currency

Take a look at the Format function in Word VBA Help. An example:

TextBox3.Value = Format$( _
    TextBox1.Value * TextBox2.Value, _
    "##,##0.00")

--
Hope this helps.
ibby

Please post replies or follow-ups to the **newsgroup** so that participants
may benefit or contribute.



Thu, 18 Sep 2003 22:37:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Format the value in a textbox

2. Assigning value to textbox if textbox is a variable name

3. Changing the textbox's value of a textbox in a frame

4. textbox format changes from short to long

5. Format a textbox

6. Formatting the text in many textboxes

7. Textbox Formatting

8. textbox formats

9. Format textbox for currency

10. Formatting text in textboxes

11. Select/format All Textboxes the same....

12. date in textbox and other format options

 

 
Powered by phpBB® Forum Software