+ Reply to Thread
Results 1 to 7 of 7

Automate draw arrows

  1. #1
    Registered User
    Join Date
    12-07-2016
    Location
    Gainesville, GA
    MS-Off Ver
    2010
    Posts
    5

    Automate draw arrows

    I haven't worked with VBA in many years but used to be fairly good at it. If you don't use it, you lose it, as they say!
    I'd like to create an automated arrow that will go through the spreadsheet starting at a specific cell and draw an arrow from column a to column c if column d is not "null". The arrow will need to go from the left mid point of the first cell to the right mid point of the cell in column c. The arrows will need to be drawn from the bottom of the spreadsheet to the top of the spreadsheet and I'd like to be able to tell the code to start looking at at a specific cell and stop looking at a specific cell. I've spent the entire day going through tutorials and looking at some code created by Ryan Wells without any luck.
    I've tried to attach an image and insert an image but haven't had any luck with that so I hope I've explained it well enough for someone out there to give me some help, which will be very much appreciated!
    Thanks!
    Denise

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Automate draw arrows

    Try the VBA below in the attached workbook.
    Modify to suit your needs

    Amend the values in columnD (replace blanks with values and values with blanks)
    then
    Run the VBA with {CTRL} + t

    Note that the variables are declared at the top of the module
    VBA names the arrows so that they can be deleted before the procedure is run again

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-07-2016
    Location
    Gainesville, GA
    MS-Off Ver
    2010
    Posts
    5

    Re: Automate draw arrows

    Thank you so much! I don't have time to look at this today but it will be first thing on my agenda Monday! Have a wonderful weekend!

  4. #4
    Registered User
    Join Date
    12-07-2016
    Location
    Gainesville, GA
    MS-Off Ver
    2010
    Posts
    5

    Thumbs up Re: Automate draw arrows

    We got this to work with a little help from your code. Thanks again so much for the help!

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Automate draw arrows

    You are welcome
    If your original question is solved please go to Thread Tools at top of thread and Mark thread as solved. You can continue to ask related questions here.
    How about clicking on * (to add reputation points) if anyone has helped you solve a problem

  6. #6
    Registered User
    Join Date
    12-07-2016
    Location
    Gainesville, GA
    MS-Off Ver
    2010
    Posts
    5

    Re: Automate draw arrows

    Hey there kev_,
    I don't have a "solved" option under my thread tools.
    can you show me a picture of what you see?
    Thanks!

  7. #7
    Registered User
    Join Date
    12-07-2016
    Location
    Gainesville, GA
    MS-Off Ver
    2010
    Posts
    5

    Re: Automate draw arrows

    Nevermind, I wasn't logged in and it showed up once I logged in. Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Up Down Arrows
    By THEQ100 in forum Excel General
    Replies: 1
    Last Post: 04-16-2015, 02:34 AM
  2. Automate Arrows
    By jsohng in forum Excel General
    Replies: 4
    Last Post: 02-14-2011, 03:55 PM
  3. draw arrows using formula
    By gary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2005, 08:05 AM
  4. [SOLVED] Up Arrows / Down Arrows
    By Charles T. Garrett in forum Excel Formulas & Functions
    Replies: 51
    Last Post: 09-06-2005, 07:05 AM
  5. Up Arrows / Down Arrows
    By MWH in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Up Arrows / Down Arrows
    By MWH in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Up Arrows / Down Arrows
    By MWH in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-03-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1