Excel UserForm Textbox - currency format

[vbviktor]

I can't figure out how to format a Textbox in a Userform to show a value (received from a currency variable) with 2 digit decimal format with a dollar sign. Can someone illuminate me.... thanks

 

[DarkSun]

This line will change the format of the text.

TextBox1.Text = Format(TextBox1.Text, "$##,###,###.##&quot

you just need to put it in the right event so that it changes the format at the right time.