displaying input data on user form as currency
 

Hello
Im trying to find a property or a way to format a text box on a user form to
show as currency when input. Can't seem to find how to do this anywhere.
Can anyone help
Thanks
Ian

displaying input data on user form as currency
 

TextBox1.Value = Format(YourSource, "$##,###.##")

Substitute the Range, Cell or Value that you want to convert as "YourSource".


"mantrid" wrote:

Hello
Im trying to find a property or a way to format a text box on a user form to
show as currency when input. Can't seem to find how to do this anywhere.
Can anyone help
Thanks
Ian

displaying input data on user form as currency
 

I might have been a little hasty in the example I gave you. At any rate, you
will need to use the Format function to convert your value to the currency
format prior to entering it into the TextBox. I don't believe Excel supports
formatting the TextBox itself to display values as currency.

"mantrid" wrote:

Hello
Im trying to find a property or a way to format a text box on a user form to
show as currency when input. Can't seem to find how to do this anywhere.
Can anyone help
Thanks
Ian