Currency conversion insert currency symbol

Hello yudlugar, it only works for USD, when i try in GBP, it gives me an error: Type mismatch

If ComboBox1.Value = "USD" Then
TextBox2.Value = Format(TextBox1.Value * 1, "$##,###")
TextBox1.Value = Format(TextBox1.Value, "$##,###")

Exit Sub
End If

If ComboBox1.Value = "GBP" Then
TextBox2.Value = Format(TextBox1.Value * 1.55, "GBP##,####")
TextBox1.Value = Format(TextBox1.Value, "GBP##,###")
Exit Sub
End If

can anyone help me on this?

anyone please

Like yudlugar said try

Textbox1.Value = "$" & Textbox1.Value

But know that because the symbol ($) is part of the string, it cannot be used in a formula.

You could try not using the $ sign at all, and set up a table with a $ as a column header. That way you use text for labels only and numbers for values only.

another thought, set up a label on your userform, place it next to the USD textbox. In this Label, change the settings so that it shows $ symbol, and change colour setting so it matches your background