software

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(quot;Inputquot;).Range(quot;I7quot;).Value
TextBoxFV_BOY.NumberFormat = quot;$#,##0quot;

But this did not work,
Does anyone know how to do this?

Thanks for your help

How about:
TextBoxFV_BOY.value = format(Sheets(quot;Inputquot;).Range(quot;I7quot;).Value, quot;$#,##0quot;)
or
TextBoxFV_BOY.value = Sheets(quot;Inputquot;).Range(quot;I7quot;).text
(if the cell is nicely formatted)

Jeff wrote:
gt;
gt; Hi,
gt;
gt; I want an Input Box to output the value of other inputs in the form, and the
gt; output is in dollars so I tried
gt;
gt; in the Click event
gt; TextBoxFV_BOY = Sheets(quot;Inputquot;).Range(quot;I7quot;).Value
gt; TextBoxFV_BOY.NumberFormat = quot;$#,##0quot;
gt;
gt; But this did not work,
gt; Does anyone know how to do this?
gt;
gt; Thanks for your help

--

Dave Peterson