Interactive Graph with Rollover Hyperlinks and UDFs

[gshocker08]

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

[6StringJazzer]

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.

[teylyn]

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

[gutswe]

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.

[teylyn]

gutswe,

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

thanks,