Completed

I need Excel VBA expert that can help m e

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.

Skills: Excel, Visual Basic, Data Processing, Visual Basic for Apps, VB.NET

See more: vba coder, excel experts, ask excel expert online free, vba expert certification, need an excel expert, excel expert online chat free, vba help online, excel vba resources

About the Employer:
( 0 reviews ) Lexington, United States

Project ID: #22675840

Awarded to:

luiswilliam

Hi, e1128! I read the description of your project thoroughly. I understand your requirements initially and I have experiences of the field. I am a specialist of: * React.js, Angular and Vue.js for Front-end, * .NET More

$50 USD / hour
(7 Reviews)
4.4

8 freelancers are bidding on average $51/hour for this job

zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the ag More

$50 USD / hour
(124 Reviews)
7.3
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$55 USD / hour
(99 Reviews)
6.7
periyannas

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.

$50 USD / hour
(111 Reviews)
6.3
Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs i am very interested in this project , i can write small vba code to colorize each currency as on the attached image will do it for 50$ only , can do it within 1 hour More

$50 USD / hour
(88 Reviews)
5.3
palinco2003

Good day, I am Paul, a professional web researcher and excel sheet data expert. I have read your order details. And really understand the data and information you want. I have helped other clients with similar tasks More

$50 USD / hour
(10 Reviews)
4.0
dataEntryExperty

I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$50 USD / hour
(12 Reviews)
3.1
MaLiguo

⭐⭐⭐⭐⭐ Greetings Dear Client! ⭐⭐⭐⭐⭐ Professional Data Entry in Excel (VBA + MACRO) program developer is ready for your project! I have gone through your description and I'm very interesting as an expert in this field. I More

$50 USD / hour
(0 Reviews)
0.0