Displays numbers as $ on a form

  • Thread starter Thread starter Southern at Heart
  • Start date 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.
 
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
 
Back
Top