• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interactive dashboard - using Hyperlinks

vletm

Excel Ninja
RonnyB
Your uploaded file have none (cannot have) VBA code ... cannot comment Your code.
Data-sheets cell E20 should be Indicator 3 ... with same logic with cell E4
... then You'll get something working.
 

RonnyB

New Member
RonnyB
Your uploaded file have none (cannot have) VBA code ... cannot comment Your code.
Data-sheets cell E20 should be Indicator 3 ... with same logic with cell E4
... then You'll get something working.
Your right about the data sheet. However it should change according to the selection on the blad 1 sheet. Wich it doenst :(

The VBA code to change it is:
>>> use code - tags <<<
Code:
Public Function highlightSeries(seriesName As Range)
    Range("valSelOption1") = seriesName.Value
    Range("valSelOption2") = seriesName.Value
End Function
 

vletm

Excel Ninja
RonnyB
As I tried to write
Your uploaded file have none (cannot have) VBA code ... cannot comment Your code.
Without real sample file - I won't even guess.
 
Top