fornat UserForm field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

I have the following:

TextBox3.Value.Format = "$#,##0.00"

I am trying to format the UserForm field to have zero decimal places, and
another field to be a percent.

How?

Thanks in advance,
geebee
 
"$#,##0" will get rid of the decimal places.

Could you clarify the percentage requirement. Maybe you want another text
box?
Or are you working with a combo box or list box? I don't understand the
separate field remark.
 
TextBox3.Value = Format(TextBox3.Value,"$#,##0.00")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top