Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Digits after the comma in Userform
In my database-sheet there are amounts, that can have one digit after the
comma (f.a. 540,7 or 540). In my userform I want these amounts shown as $540,70 / $540,00. How can I do that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Digits after the comma in Userform
Try this
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) textbox1.Text=format(textbox1.Text,"$0,00") End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gert-Jan" wrote in message ... In my database-sheet there are amounts, that can have one digit after the comma (f.a. 540,7 or 540). In my userform I want these amounts shown as $540,70 / $540,00. How can I do that? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Digits after the comma in Userform
Thanks, Bob.
I changed the code a bit, now it works fine: (mb2 =label) mb2.Caption = Range("Sheets3!Q3").Value mb2.Caption = Format(mb2.Caption, "?0.00") Gert-Jan "Bob Phillips" schreef in bericht ... Try this Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) textbox1.Text=format(textbox1.Text,"$0,00") End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gert-Jan" wrote in message ... In my database-sheet there are amounts, that can have one digit after the comma (f.a. 540,7 or 540). In my userform I want these amounts shown as $540,70 / $540,00. How can I do that? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Digits after the comma in Userform
Hi Gert-Jan,
If you are getting data from a cell, and that cell is already formatted, you could just use mb2.Caption = Range("Sheets3!Q3").Text or at least do it in one move mb2.Caption = Format(Range("Sheets3!Q3").Value, "?0.00") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gert-Jan" wrote in message ... Thanks, Bob. I changed the code a bit, now it works fine: (mb2 =label) mb2.Caption = Range("Sheets3!Q3").Value mb2.Caption = Format(mb2.Caption, "?0.00") Gert-Jan "Bob Phillips" schreef in bericht ... Try this Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) textbox1.Text=format(textbox1.Text,"$0,00") End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gert-Jan" wrote in message ... In my database-sheet there are amounts, that can have one digit after the comma (f.a. 540,7 or 540). In my userform I want these amounts shown as $540,70 / $540,00. How can I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change single digits to recognized double digits? | Excel Worksheet Functions | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
Inserting comma(,) after every two digits of a number from right t | Excel Worksheet Functions | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Display numbers in a userform txtfield as numbers with a comma | Excel Programming |