Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency in Userform
Hello,
Office 2000 on Windows NT. Is there any way to display the "$" in a userform? I have it on the worksheet, but would like to display it in the textbox on the userform. Also, I have used the "Round" on the worksheet to display only 2 decimal places in the same textbox. Is there another way to do this? Appreciatively, Al |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency in Userform
Textbox1.Text = Range("A1").Text
-- Regards, Tom Ogilvy "Fixital" wrote in message ... Hello, Office 2000 on Windows NT. Is there any way to display the "$" in a userform? I have it on the worksheet, but would like to display it in the textbox on the userform. Also, I have used the "Round" on the worksheet to display only 2 decimal places in the same textbox. Is there another way to do this? Appreciatively, Al |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency in Userform
Hi Fixital
You can use the format function Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) Me.TextBox1.Text = Format(TextBox1, "your format") End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Fixital" wrote in message ... Hello, Office 2000 on Windows NT. Is there any way to display the "$" in a userform? I have it on the worksheet, but would like to display it in the textbox on the userform. Also, I have used the "Round" on the worksheet to display only 2 decimal places in the same textbox. Is there another way to do this? Appreciatively, Al |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency in Userform
Al,
If you are wanting to format user input, you need to do it at the end, or as it is input. The formatting is done with Textbox1.Text = Format(Textbox1.Text,"$#,##0.00") That shows the currency and the number of dec places. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Fixital" wrote in message ... Hello, Office 2000 on Windows NT. Is there any way to display the "$" in a userform? I have it on the worksheet, but would like to display it in the textbox on the userform. Also, I have used the "Round" on the worksheet to display only 2 decimal places in the same textbox. Is there another way to do this? Appreciatively, Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox on a userform - format to currency & percent | Excel Discussion (Misc queries) | |||
UserForm TextBoxes - Is there a way to format as currency or perce | Excel Discussion (Misc queries) | |||
Currency Format on UserForm when opened! | Excel Discussion (Misc queries) | |||
Userform Textbox Currency Format Problems | Excel Programming | |||
Textbox on a userform.. dispaly as currency | Excel Programming |