Format textbox to currency

Hi Forum,
The below code formats a textbox to different currencies based on user selection from a combobox, it uses a vlookup function to determine which format to use (here is a sample workbook CurrencyFormatting.xlsm )
The issue is that the code only recognizing the USD currency and not the other currencies.

Please Login or Register  to view this content.

I would really appreciate any help on this.

Thanks in advance.

Hi Norie,
The vlookup does not return any symbols except if the US currency is selected.
In my posted workbook you will see what i mean if you try to select a different currency.