Results 1 to 12 of 12
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    I devised a small addin that shows two arrows pointing at the current location of the cell pointer.
    It has a small toolbar with enable/disable buttons and a button to "lock" the current two arrows.

    ###EDIT###: New version with two bug fixes.
    ###EDIT###: New version with bug fixes.
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Nice.

    Is there a way to change the line width and arrow head size?

    I could look through the code, but it is easier to ask.

    IGNORE That request, I Just Looked in the code!

    Be Nice to Have it on the mini toolbar as a configuration option.
    Andrew

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I thought of that, but hey, if you can find it in the code...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Very sweet, now I just need a version with a cluebat!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Had a little tinker with this.
    More academic than practical
    But now have a tool to change Line width and colour off the Menu
    Would like to use a normal colour mixer rather than RGB Numbers, but still working on that.
    If it gets to a point where I think it is worth it, I'll post it back.

    [attachment=88425:FollowCellConfig.jpg] [attachment=88426:FollowCellDemo.jpg]
    Attached Images Attached Images
    Andrew

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've updated the add-in with some features (not color though)...
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Just looking into this now.

    Is it possible to set the arrows so that they do not print.
    Andrew

  8. #8
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have added Colour and Line Style plus more Weights.
    However, cannot get Non Printing of line to work.

    moPtr objects ought to support the PrintObject=False Property I think.

    However IF you remove the On Error Resume Next, it fails
    with a Property / Method not found Error.

    Not sure why because it can be set for a normal line or arrow.

    OOPS I Appear to have posted the WRONG ADD IN File Yesterday (Edited 8th April 11.00 am)

    Here is the correct one [attachment=88464:CellPointer.zip]
    Attached Files Attached Files
    Andrew

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Updated with a beforeprint event to make the arrows go away when printing.
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    That is where I was getting it wrong then.

    I was trying to include it in the CLASS Module

    SetPointers Sub where the other parameters are set.
    Andrew

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Update which remembers the toolbar position...
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    New Lounger
    Join Date
    Aug 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    how can I set follow-cell-pointer "dissable" by default?

Posting Permissions

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