[Solved]Forex Strength Spreadsheet Project Useful Rank Foreign Exchange Currencies Time Identify M Q37172972
Nested For-Statements and Nested Do-Loops are to be used in thisVBA Subroutine, thanks.
Forex Strength Spreadsheet Project 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 UPY, 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 9-mo 6-mo 3-mo 1-mo 10-day NZD AUD CAD 1 1-yr NZD NZD AUD NZD NZD AUD 4 CHF 5 NZD 6 EUR RUN AUD EUR CHF CHF EUR EUR CHF EUR CAD CHF USD CHF 8 CAD EUR 10 Show transcribed image text Forex Strength Spreadsheet Project 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 UPY, 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 9-mo 6-mo 3-mo 1-mo 10-day NZD AUD CAD 1 1-yr NZD NZD AUD NZD NZD AUD 4 CHF 5 NZD 6 EUR RUN AUD EUR CHF CHF EUR EUR CHF EUR CAD CHF USD CHF 8 CAD EUR 10
Expert Answer
Answer to Forex Strength Spreadsheet Project It is useful to rank foreign exchange currencies over time to identify market trends … . . .
OR
