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
Bookmarks