| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting text boxes
I have 3 text boxes on a form and a label that show the
sum of the 3. How do I format the text boxes and label so it shows currency. If user enters 123 I want it to display as $ 123.00 in the text box and in the label. Thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formatting text boxes
Hi Doug
Use format: TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $") HTH Cordially Pascal "doug" a écrit dans le message de news: ... I have 3 text boxes on a form and a label that show the sum of the 3. How do I format the text boxes and label so it shows currency. If user enters 123 I want it to display as $ 123.00 in the text box and in the label. Thanks for your help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formatting text boxes
Thanks, but there is still a glitch. When I enter a 2 I
get 2 $ and a "type mismatch" error message. I found this "$#,##0.00_);[Red]($#,##0.00)" in the help menu, but I can't get it to work either. Help!! -----Original Message----- Hi Doug Use format: TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $") HTH Cordially Pascal "doug" a écrit dans le message de news: ... I have 3 text boxes on a form and a label that show the sum of the 3. How do I format the text boxes and label so it shows currency. If user enters 123 I want it to display as $ 123.00 in the text box and in the label. Thanks for your help . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formatting text boxes
What event did you put it in? Should be AfterUpdate or Exit, but not
Change. -- Regards, Tom Ogilvy "Doug" wrote in message ... Thanks, but there is still a glitch. When I enter a 2 I get 2 $ and a "type mismatch" error message. I found this "$#,##0.00_);[Red]($#,##0.00)" in the help menu, but I can't get it to work either. Help!! -----Original Message----- Hi Doug Use format: TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $") HTH Cordially Pascal "doug" a écrit dans le message de news: ... I have 3 text boxes on a form and a label that show the sum of the 3. How do I format the text boxes and label so it shows currency. If user enters 123 I want it to display as $ 123.00 in the text box and in the label. Thanks for your help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to select multiple text boxes in excel for formatting | New Users to Excel | |||
| Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
| User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
| How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
| Allow Word type formatting in Excel text boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
