| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
displaying input data on user form as currency
Hello
Im trying to find a property or a way to format a text box on a user form to show as currency when input. Can't seem to find how to do this anywhere. Can anyone help Thanks Ian |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
displaying input data on user form as currency
TextBox1.Value = Format(YourSource, "$##,###.##")
Substitute the Range, Cell or Value that you want to convert as "YourSource". "mantrid" wrote: Hello Im trying to find a property or a way to format a text box on a user form to show as currency when input. Can't seem to find how to do this anywhere. Can anyone help Thanks Ian |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
displaying input data on user form as currency
I might have been a little hasty in the example I gave you. At any rate, you
will need to use the Format function to convert your value to the currency format prior to entering it into the TextBox. I don't believe Excel supports formatting the TextBox itself to display values as currency. "mantrid" wrote: Hello Im trying to find a property or a way to format a text box on a user form to show as currency when input. Can't seem to find how to do this anywhere. Can anyone help Thanks Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying data in user form from active worksheet | Excel Programming | |||
| How do I create a User form to input Data into an Ecel spreadsheet | Excel Programming | |||
| displaying the user form data | Excel Programming | |||
| Currency format for combo box in a user form | Excel Programming | |||
| Data Input - User Form Drop-Down Box | Excel Programming | |||
Hybrid Mode
