Exchange rates display

**akhmoud** · 07-01-2013, 02:52 PM

Dear all,
I have a certain problem I would like to ask you to help with

I am asked to develop and document (Using VBA) a subroutine that allows the user to query exchange rates across three
currencies. I have to prepare a spreadsheet that stores a table of exchange rates across three currencies that the
user can fill in before the program runs.
For example to illustrate I will use the following rates :
1 GBP = 1.12952 EUR 1 EUR = 0.885329 GBP
1 GBP = 1.64004 USD 1 USD = 0.609740 GBP
1 USD = 0.688735 EUR 1 EUR = 1.45194 USD
At run time the user simply states the source and destination currencies and my sub should output
to the screen the relevant exchange rate picked out from the table.

I am sure its not a very difficult code to write, but since I am new to VBA i'm finding it difficult to do so.
your help is much appreciated.

Thank you dearly,
Karim

**humdingaling** · 07-02-2013, 01:50 AM

as you are starting from scratch

there are some step by step videos on youtube that shows you exactly how to get one down
just search for "Currency Converter Part 4" on youtube

the only thing you need to worry about really is where/how your source data will be updated

**humdingaling** · 07-02-2013, 02:02 AM

hmm re-reading your request

do you really require vba? what is the intent/expected outcome for using VBA?
you could just setup two drop down lists via data validation and have output on worksheet instead of using VBA?