Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20

  • Hi there - I would like code that creates or simulates a hyperlink between a cell one one worksheet and a cell on another wksheet in the same wkbook. The hyperlink needs to go both ways. The hyperlinked cells should be underlined or color formatted, making users aware of the link.



    The link should be instantiated by a command in the right-click menu (right-clicking the first cell to be linked), or a triple-click of the first cell (this may be quicker than a right-click, menu item). The code then would "wait" until the second cell to be linked back to the first cell is selected somehow--such as with a double-click. The code should allow users to click sheet tabs, arrow keys, etc. in order to navigate to the second cell to be linked. A double-click or right-click on the second cell should end the linking process and code.



    Clicking a linked cell on either sheet will take the user to the linked cell in the other sheet.



    I've read about storing the first cell's (active cell's) reference as a variable, but don't know how to capture the ref of the second cell to be linked.


    Thanks!



    Here are some threads I was exploring:



    http://www.ozgrid.com/VBA/right-click.htm
    http://www.ozgrid.com/forum/showthread.php?t=39696
    http://stackoverflow.com/quest…oto-functions-ctrl-and-f5

  • Re: Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20


    Question?


    Basically you want to be able to Set any cell as a hyperlink then navigate to another cell and create a loop to each other?

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20


    I have re-read and understand your request and will pass. Good luck

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20


    Hi S M C, in order for a user to navigate to the other cell in the other sheet, they will likely have to single click--or they could easily make a single click mistake. This is why a double-click or right-click menu command might be easier. Thoughts? I have to be out for about 2 hours...

  • Re: Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20


    This is what I have. If it works for you, I'll send you my paypal ID. Else, open to others.


  • Re: Making hyperlinking between 2 cells in 2 sheets user-friendly, USD $20


    Thanks S M C - that works for me. I actually like the msgbox--easier for the user. Pretty cool, thanks. This is solved; you may send me your ID.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!