Displays numbers as $ on a form
 

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.

Displays numbers as $ on a form
 

On Jan 3, 11:26*am, Southern at Heart
wrote:
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.



Try this

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

HTH
Joe