+ Reply to Thread
Results 1 to 5 of 5

Interactive Graph with Rollover Hyperlinks and UDFs

  1. #1
    Registered User
    Join Date
    08-09-2011
    Location
    new york
    MS-Off Ver
    excel 2010
    Posts
    3

    Interactive Graph with Rollover Hyperlinks and UDFs

    Hi, I'm using Chandoo's method of creating interactive graphs with hyperlinks and a simple macro. As a formula he has a hyperlink to a user-defined function (UDF). When you rollover the cell, the UDF begins.

    The UDF is very short---it is

    Public Function highlightSeries_(seriesName As Range)
    Range("valSelOption_") = seriesName.Value
    End Function

    My problem is that whenever I change this UDF, it breaks. For example, I wanted to make it so I set a defined name range valSelOption was equal to another defined name range seriesName (currently it is one cell being changed to another value). However, it will not work, nor will changing simple other things to the UDF. Anyone have any suggestions? Thanks.

    Also the debugger with a break point never seems to get hit whenever I roll over the UDF and it seemingly runs (interactive graph changes the series it shows).

    http://chandoo.org/wp/2011/07/20/int...comment-207935

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,364

    Re: Interactive Graph with Rollover Hyperlinks and UDFs

    This is a really interesting technique. It would never have occurred to me that you can put a function in a HYPERLINK argument, and that the function would be evaluated on rollover. I downloaded the example file from the site you referenced, and also created my own pared-down version to confirm that I understood what was going on.

    I do not know why the debugger doesn't kick for breakpoints here, but I confirmed you are correct about that.

    To help you I would have to see at least one concrete example of the change you're trying to make. You said "it will not work" but you have to be more specific. Do you mean that it does the wrong thing? That it doesn't do anything? That you get an error message? I was able to make changes, including adding a call to MsgBox, and had no problem.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Interactive Graph with Rollover Hyperlinks and UDFs

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

  4. #4
    Registered User
    Join Date
    09-07-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Interactive Graph with Rollover Hyperlinks and UDFs

    Hi ,

    Can you please help me with the issue im facing . Im using the same workbook from chandoos site.

    The problem is i have a formula (hyperlink function) in cell G3. When i rollover the charts are changing as expected. But in G3 cell value previously displayed , changed on rollover.
    And if i save the workbook or go to the formula bar in any cell & hit enter ... value in G3 is getting displayed properly.

    Attaching the workbook for reference.
    Attached Files Attached Files

  5. #5
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Interactive Graph with Rollover Hyperlinks and UDFs

    gutswe,

    welcome to the forum. Please have a look at the forum rules and then start your own question.

    thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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