View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vinod[_2_] Vinod[_2_] is offline
external usenet poster
 
Posts: 72
Default Currency automation

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