Visual basic programming in Excel

This project was successfully completed by buyaspreadsheet for $82 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
Project Description

I have an excel file file with some Visual Basic programming that needs a little addition.

The arrows and bands displayed by the program need to show values on top of the objects.

I am attaching the excel file with current programs (Macros). When you run the macro "Setshape" on worksheet named "ADR", it creates a white arrow and a blue band for each ticker.

The addition I need is to display start and end point values for these objects.

See attachment "Before" to see current setup. Then see attachment "After" to see what I want to do. Note- display is not limited to just first five objects I only did it by hand to show you how the project need to be done. You have to program it all the way for each 20plus objects.

So this is what you need to do: grab "arrow" values from the table to the right on "[url removed, login to view]" file and font type "Ariel" size 10 display them above arrow. "Today" price font is bold.

Same way, you display TE Lo and TE Hi values within the blue band. Font I used is Arial, size 8, color white.

Thank you for your cooperation.

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online