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.
 
You must log in or register to reply here.

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

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Form Refresh 1
How to have a listbox display currency 1
somewhat complicated conditional formula 2
VBA currency or percent format object 1
Change currency on all sheets based on one cell value 3
Precision as displayed for certain cells only 3
Format currency in MsgBox 3

Back
Top