strange behaviour from vba

hi to you all,

i have created a vba that will do a currency conversion, to be exact someone on this forum has helped me. Basically on the introduction worksheet you select the country and push on the set button and this correclty format all currency fields into the selected countries currency.

something however is seriously wrong as when i push on the set button, i get values appearing in non currency fields for some reason.

Can someone please help and tell me where i have gone wrong,

For Some reason it was not picking up the first currency field on the worksheet, so i converted the cell to a custom currency field.

Also i would ideally like the currency simbol to appear in a colum next to the set button, but when i try to add a column it messes up the entire worksheet.

really appreciate your help,