Formatiing a input Box in a Userform
 

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