Currency conversion insert currency symbol

Hello, i just want to insert the currency symbol in textbox, however there's a formula on it:

Ex: If Combobox1 is GBP, when i type a number in textbox1 for example "100", input will be "100 £" and textbox2 will be "155 $".

Currency symbol:

EUR = €
GBP = £
USD = $
DKK = kr
NOK = kr

Textbox1 will be Local Currency and Textbox2 will be conversion amount in USD.

Please Login or Register  to view this content.

I'm not sure if it is possible to apply a formatting to a textbox the same way you would in excel, I'm not aware of any methods for this, therefore the best you could do would be something like:

Please Login or Register  to view this content.

or just

Please Login or Register  to view this content.

However, this can lead to quite a few problems as it will leave you with the format as part of the string, which you will then try and perform arithmetic with - you would probably need to add quite a lot of error handling to cope with if the user enters just a number, or edits the existing value and leaves the currency symbol etc. You already have the currency selected in the box above - it's probably quite a lot of work just to get a symbol that doesn't tell you anything you don't know already. Or have the currency symbol as a label to the left of the textbox.

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

Please Login or Register  to view this content.

can anyone help me on this?

anyone please

Like yudlugar said try

Please Login or Register  to view this content.

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