fornat UserForm field
 

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

fornat UserForm field
 

"$#,##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.

"geebee" wrote:

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

fornat UserForm field
 

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

--
HTH

Bob Phillips

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

"geebee" wrote in message
...
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