Userform Formating
 

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

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