Consulting

Results 1 to 5 of 5

Thread: draw arrows

  1. 07-27-2011, 02:54 AM #1
    ganeshr
    ganeshr is offline
    VBAX Regular
    Joined
    Jul 2011
    Posts
    12
    Location

    draw arrows

    Hi there.i 've a code which find precedents of a formula. i want a code that draw arrows between the cells. For example, if the formula is entered as c7=e4+f9 . then the arrows should be immediately drawn from the cell e4 to c7 and from f9 to c7 after the precedent cells are shown. so far i 've run the code to display precedent cells.
    Reply With Quote Reply With Quote
  2. 07-27-2011, 03:07 AM #2
    Aflatoon
    Aflatoon is offline
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    Since that is built-in functionality, why are you replicating it?
    Be as you wish to seem
    Reply With Quote Reply With Quote
  3. 07-27-2011, 03:30 AM #3
    ganeshr
    ganeshr is offline
    VBAX Regular
    Joined
    Jul 2011
    Posts
    12
    Location
    i just want to make VBA code to draw arrows between specific cells.
    Reply With Quote Reply With Quote
  4. 07-27-2011, 03:41 AM #4
    Aflatoon
    Aflatoon is offline
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    I understand but since
    [vba]Range("C7").ShowPrecedents[/vba]
    will do that automatically, I do not really follow why you are trying to reinvent it.
    Be as you wish to seem
    Reply With Quote Reply With Quote
  5. 07-29-2011, 12:26 PM #5
    Actuary1010
    Actuary1010 is offline
    VBAX Regular
    Joined
    Jul 2011
    Posts
    10
    Location
    Are you doing option pricing using Binomial model?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules