Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post - Excel VBA Question - Changing Format Cell To Particular Currency

iggyntangs · 11-14-2014, 10:03 AM

Hi all,

I've been trying to do IF statements and case statements to achieve this and nothing has been remotely successful.

Basically I have a 5 tab workbook that has different named ranges within each sheet that are meant to be a currency format.

However based on the value of a cell in the 1st tab (e.g. it could be CAD, USD, NOK, etc.) the currency format on those range of cells should change.

I.e. If the cell value in tab 1 is equal to CAD then all the named ranges in tabs 2-5 should be "$", if USD still "$", if NOK "kr " etc.

Any help would be greatly appreciated!

11-14-2014, 10:03 AM	#1
iggyntangs Scoring Winger Join Date: Oct 2010 Exp:	Excel VBA Question - Changing Format Cell To Particular Currency Hi all, I've been trying to do IF statements and case statements to achieve this and nothing has been remotely successful. Basically I have a 5 tab workbook that has different named ranges within each sheet that are meant to be a currency format. However based on the value of a cell in the 1st tab (e.g. it could be CAD, USD, NOK, etc.) the currency format on those range of cells should change. I.e. If the cell value in tab 1 is equal to CAD then all the named ranges in tabs 2-5 should be "$", if USD still "$", if NOK "kr " etc. Any help would be greatly appreciated!