+ Reply to Thread
Results 1 to 3 of 3

VBA that will 'click' a dynamic link to another sheet

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    58

    VBA that will 'click' a dynamic link to another sheet

    Apologies if I use the wrong wording here, but I have a dynamic hyperlink to one of 50 sheets in cell G5 - it changes depending on what is selected in G6. It looks like this;

    Please Login or Register  to view this content.
    I would like a piece of VBA code that, whenever G6 is changed, the hyperlink in G5 is 'clicked'.

    Is this possible? I've searched all over the web and cannot find an answer. Thanks in advance.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,621
    Instead of using the hyperlink in G6 why not use code triggered by a change in G5?

    That code could either hyperlink to the selected sheet using FollowHyperlink or goto the sheet using Application.Goto.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-29-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: VBA that will 'click' a dynamic link to another sheet

    Quote Originally Posted by Norie View Post
    Instead of using the hyperlink in G6 why not use code triggered by a change in G5?

    That code could either hyperlink to the selected sheet using FollowHyperlink or goto the sheet using Application.Goto.
    Thanks for that, that's a good idea, yes. The hyperlink would have to be dynamic, like it is in the cell. Do you know how I could structure that into VBA code?

+ 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. [SOLVED] Click link to go to sheet in another workbook
    By fastcar in forum Excel General
    Replies: 1
    Last Post: 01-17-2012, 10:08 PM
  2. Excel 2007 dynamic values sheet 1 on click
    By marinemerchant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2011, 04:18 PM
  3. Click on a Link
    By Wanting_To_Learn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2011, 11:23 AM
  4. How Do I save a Camera Icon Dynamic Picture Link created in the Sheet itself?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2011, 01:58 PM
  5. How to "link" cells in one sheet to cells in another sheet just by a click?
    By smartankan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2010, 03:01 AM

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