Userform Formating

J

Jeff

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
 
D

Dave Peterson

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)
 
Top