Hi

I want to build a VBA function that converts one currency to another. I'm pretty new to using Functions and have spent way too long trying to figure this out.

I want something like this:

Exchange = (VAL, CURRENCYFROM, CURRENCYTO)

So the user can enter the value, currency from and to and it'll give them the exchange rate. I want this on a function so that it can be used in any report rather than having to always open a separate worksheet for this.

Ideally, I wanted this to look into a spreadsheet on a server so it will always have the latest rates, but I couldn't get this to work so happy to list all the rates in the code but still having no luck.

Any clues would really be appreciated