Displays numbers as $ on a form

  • Thread starter Southern at Heart
  • Start date
S

Southern at Heart

If a textbox is showing a value from a cell, can you format the textbox as
currency ($)... The cell has this formatting set to it, but it doesn't carry
over to the userform.
thanks.
 
J

Joe

If a textbox is showing a value from a cell, can you format the textbox as
currency ($)...  The cell has this formatting set to it, but it doesn't carry
over to the userform.
thanks.
Click to expand...



Try this

K = 50.449876 ' or a cell value
T.Value = Format(K, "0.00") & "$" 'TextBox

HTH
Joe
 

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

Simple formatting question 2
Userform Text box Format to Currency 2
VBA currency or percent format object 1
Textbox Formatting Trouble 3
Userform textbox string to header causes unwanted double spacing 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Dateadd function question.. 0
VB Date Format 8

Top