displaying input data on user form as currency

  • Thread starter Thread starter mantrid
  • Start date Start date
M

mantrid

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top