VBA exchange rate calculator, help where to begin??

[olivierv]

Hi guys,

I need to build an exchange rate calculator in VBA. Has anyone of you done this before? Or maybe someone has some comparable code that helps me in the right direction?

"Develop and document a subroutine that allows the user to query exchange rates across threecurrencies. Prepare a spreadsheet that stores a table of exchange rates across three currencies that theuser can fill in before the program runs.For example to illustrate you could 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 your sub should outputto the screen the relevant exchange rate picked out from the table.Make assumptions and create appropriate visual basic loops to demonstrate how such a model can beused in day to day business decisions."

 

[Macropod]

Under 'General Netiquette' (MrExcel Message Board FAQ) you'll see:
"Most people around here have done their share of school (and college) homework, so don't expect that people around here will do it for you."