Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How about:
TextBoxFV_BOY.value = format(Sheets("Input").Range("I7").Value, "$#,##0") or TextBoxFV_BOY.value = Sheets("Input").Range("I7").text (if the cell is nicely formatted) Jeff wrote: Hi, I want an Input Box to output the value of other inputs in the form, and the output is in dollars so I tried in the Click event TextBoxFV_BOY = Sheets("Input").Range("I7").Value TextBoxFV_BOY.NumberFormat = "$#,##0" But this did not work, Does anyone know how to do this? Thanks for your help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform that add data in all w/sheets | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
Cell Content from UserForm Not Retained | Excel Discussion (Misc queries) | |||
How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) |