Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Currency Format of Cell based on another Cell
Is there a way to dynamically change the currency format of a cell based on
the value of another cell dynamically. For isntance cell A1 holds the text value "HKD", i want to change the currency format of cell A2 to HKD. If the value in A1 is "SGD" then the currency format of A2 will be SGD? Is this possible? Thanks. Simon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Currency Format of Cell based on another Cell
Simon;
Create a column of text values for your currency. Then create a column of character values for the symbol of that corresponding currency. Then create a column of factorials based on a set currency. Do an If(lookup,Lookup,"") statement that selects the value of the factorial based on the text value that you assign in a predefined location. God Bless Frank Pytel "Simon" wrote: Is there a way to dynamically change the currency format of a cell based on the value of another cell dynamically. For isntance cell A1 holds the text value "HKD", i want to change the currency format of cell A2 to HKD. If the value in A1 is "SGD" then the currency format of A2 will be SGD? Is this possible? Thanks. Simon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Currency Format of Cell based on another Cell
Simon
You could do this using sheet event code. Option Compare Text Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub On Error GoTo endit Application.EnableEvents = False Select Case Target.Value Case "HKD" Target.Offset(1, 0).NumberFormat = "[$HKD] #,##0.00" Case "SGD" Target.Offset(1, 0).NumberFormat = "[$SGD] #,##0.00" End Select endit: Application.EnableEvents = True End Sub Right-click on the sheet tab and "View Code". Copy/paste into that sheet module. Gord Dibben MS Excel MVP On Sun, 2 Sep 2007 06:50:01 -0700, Simon wrote: Is there a way to dynamically change the currency format of a cell based on the value of another cell dynamically. For isntance cell A1 holds the text value "HKD", i want to change the currency format of cell A2 to HKD. If the value in A1 is "SGD" then the currency format of A2 will be SGD? Is this possible? Thanks. Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
How to format a cell to represent Indian Currency System? | Excel Discussion (Misc queries) | |||
In Format>Cell>Numbers>currency>Symbol Please add "Rs. India" | Excel Worksheet Functions | |||
How do I change the format of a cell based on what I input? | Excel Worksheet Functions | |||
Change Currency symbol dependant upon selected cell value | Excel Discussion (Misc queries) |