| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displays numbers as $ on a form
If a textbox is showing a value from a cell, can you format the textbox as
currency ($)... The cell has this formatting set to it, but it doesn't carry over to the userform. thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Displays numbers as $ on a form
On Jan 3, 11:26*am, Southern at Heart
wrote: If a textbox is showing a value from a cell, can you format the textbox as currency ($)... *The cell has this formatting set to it, but it doesn't carry over to the userform. thanks. Try this K = 50.449876 ' or a cell value T.Value = Format(K, "0.00") & "$" 'TextBox HTH Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserted comment not displays in the cell it displays on top row | Excel Worksheet Functions | |||
| I mail merge excell into word, but date displays numbers instead | Excel Discussion (Misc queries) | |||
| Form displays but no text | Excel Programming | |||
| Editing Numbers on a Form | Excel Programming | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
