Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm having Numaric values in a range from X18:BI52. I wanted to put a
dropdown box (Form Combo box) to select currency symbols(USD,HKD,GBP,CNY,INR). By default all values in the range according to USD, the moment when I select other currencies from the list then the values in the range should automatically calculate according to exchange rates which links to website, consists of exchange rates (suggest best link). Let say bydefault "USD". If I select "HKD", exchange rate from USD TO HKD. Later if I select "CNY", exchange rate from HKD TO CNY. Later if I select "GBP", exchange rate from CNY TO GBP. So, the exchange rate values should reflect with the existed values in the range. In otherwards, bydefault "USD" seleted. (In the range X18:BI52) X18=1.00 X19=2.00 Z24=3.00 If I select "INR" (Assume that $ 1.00 = INR 40.00) (In the range X18:BI52) X18=40.00 X19=80.00 Z24=120.00 So, when ever i selected currency then it should automatically get the exchange rate value from the website and do calculation and replace the existed values in the range. And also suggest me the best site for exchange rates to link with this sheet. Note: without VBA code. Any one help me out from this problem. Advanced Thanks, Vinod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automation | Excel Worksheet Functions | |||
printing automation | Excel Discussion (Misc queries) | |||
Automation Error | Excel Discussion (Misc queries) | |||
Automation?? | Excel Discussion (Misc queries) | |||
automation | New Users to Excel |