Determines if the current change in sheet1 The event handler will modify updated cell C2 based on the values chosen from the drop down lists: For more information about creating drop down lists in Excel please visit Excel VBA Drop Down Lists.Īfter selecting the currency code from the drop down list, a worksheet_change event will be triggered. The drop down lists were created using data validation. Column B is only for display purposes and is not used in the application. In column A you can see the currency codes, and in column B the name of the country the currency is associated with. The source of the drop down lists are in sheet 2. The final number the application will show, is the amount of currency 2 which is equal to one unit of currency 1: Currency 1 and Currency 2 are the currencies we are after:Įach currency is chosen from a drop down list. This application also allows users to select only the currency exchange (forex) rates he/she needs. You can download the codes and files related to this article here.īelow you can see the programs main interface. In this article explain how you can write an excel application to retrieve currency exchange (forex) rates from the website.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |