View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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