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

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
>
>
>

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
>
>
>