Userform Formating
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
|