| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Format on UserForm when opened!
The values of a text box on a UserForm appear as numbers. I want to diplay
the value of these text boxes in currency format when the form is opened. How do I write the code to ensure currency format is always displayed? -- Thanks, Robo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Format on UserForm when opened!
You can use something like:
Option Explicit Private Sub UserForm_Initialize() Me.TextBox1.Value = Format(1234.23, "$#,##0.00") End Sub Robo wrote: The values of a text box on a UserForm appear as numbers. I want to diplay the value of these text boxes in currency format when the form is opened. How do I write the code to ensure currency format is always displayed? -- Thanks, Robo -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Format on UserForm when opened!
help...still unable to get the UserForm (DisbSchForm) to display currency
when opened (Show). i have thirty txt boxes named txtbox01, txtbox02, txtbox03...txtbox30 & & when i type in what you told me it displays only a number? i do not want the decimal places to display & the currency amount can be up to 9 digits. -- Thanks, Robo "Dave Peterson" wrote: You can use something like: Option Explicit Private Sub UserForm_Initialize() Me.TextBox1.Value = Format(1234.23, "$#,##0.00") End Sub Robo wrote: The values of a text box on a UserForm appear as numbers. I want to diplay the value of these text boxes in currency format when the form is opened. How do I write the code to ensure currency format is always displayed? -- Thanks, Robo -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Format on UserForm when opened!
Something like this?
Me.TextBox1.Value = Format(1234.23, "$#,##0") Robo wrote: help...still unable to get the UserForm (DisbSchForm) to display currency when opened (Show). i have thirty txt boxes named txtbox01, txtbox02, txtbox03...txtbox30 & & when i type in what you told me it displays only a number? i do not want the decimal places to display & the currency amount can be up to 9 digits. -- Thanks, Robo "Dave Peterson" wrote: You can use something like: Option Explicit Private Sub UserForm_Initialize() Me.TextBox1.Value = Format(1234.23, "$#,##0.00") End Sub Robo wrote: The values of a text box on a UserForm appear as numbers. I want to diplay the value of these text boxes in currency format when the form is opened. How do I write the code to ensure currency format is always displayed? -- Thanks, Robo -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format userform text box | Excel Discussion (Misc queries) | |||
| format cells for currency 2450 and have it format to $24.50? | Excel Worksheet Functions | |||
| Change General Format to Currency Format | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) | |||
![Robo[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
