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
Bookmarks