Converting Currency Format

Hi there,

I have a spreadsheet with a number of currencies that I want the format of a cell to change to given whatever currency I have inputted in another column.

I actually found a code online that works really well if it was for 1 currency, but was wondering if someone could help change the code so that it would read for multiple currencies in different lines?

Thanks so much for the quick response! this works perfectly! Actually is it possible to change the code so that we can manually run the macro instead of a change event?

I tried switching to an Activate but then i'm getting an Object Required (Error 424) message.

Thanks!

Thanks so much for your help!!