Currency exchange VBA exercise

Make the necessary assumptions to complete your VBA model in a clear and easy to follow structure. When documenting your model, assume you are an investment analyst, portfolio manager, bank fund manager,... where you are introducing a new approach to analysing your client's reports by using VBA [login to view URL] want to persuade them to appreciate the advantages of VBA modelling and switch from using excel. Develop and document a subroutine that allows the user to query exchange rates across three or more currencies. Prepare a spreadsheet that stores a table of exchange rates across three or more currencies that the user can fill in before the program runs At Run time the user simply states the source and destination currencies and your sub should output to the screen the relevant exchange rate picked out from the table. Make assumptions of your choice and create appropriate visual basic loops to demonstrate how such a model can be used in day to day business decisions