Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Calucated Field in a Userform | Excel Discussion (Misc queries) | |||
userform Field forcing Capital Letters - Thank you | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Userform - Move to next textbox field by hitting enter instead of | Excel Programming | |||
tabbing round a userform, whole field is selected | Excel Programming |