It is useful to rank foreign exchange currencies over time to identify market trends between these currencies. One way to help identify those trends is to create a table like the one shown below were a unique color has been placed in every cell for each currency code. This assignment is to create a macro that will perform this task. Duplicate the spreadsheet shown below and construct a macro to place a unique color for each of the eight different currency codes (JPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2 through F9. The Excel spreadsheet is to be named Forex Strength. Two different independent control programs are to be written to accomplish this task. Main Program #1 will use nested FOR statements to select each cell one at a time and Main Program #2 will use nested DO loops. Both Main programs will select each cell one at a time and interrogate that cell to identify the currency code. That Main program will pass control and the currency code to a subroutine named Forexcolors. The Forexcolors subroutine will link a unique color code number to each foreign exchange and pass control that number back to the control program. The control program will then use that number to fill that cell with that unique color. Remember to dimension all variables and place a run button on the spreadsheet.
8 freelancers are bidding on average $51/hour for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.