R rush2rajen Member Nov 14, 2014 #1 Hi Excel Gurus, Please help in creating this dashboard Given the attached file. Thanks Raj Attachments Book1.xlsx 14.3 KB · Views: 10
Hui Excel Ninja Staff member Nov 14, 2014 #2 See attached You forgot to setup a ValSelOption named formula as well as use some simple VBA which is required See the original post description at: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/ Attachments Book1-2-Hui.xlsm 19.1 KB · Views: 16
See attached You forgot to setup a ValSelOption named formula as well as use some simple VBA which is required See the original post description at: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
R rush2rajen Member Nov 14, 2014 #3 Hi Hui, Thanks a lot. I was trying to make it on my own but unable as I dont know VBA. I Thought that by using simple formula I can do so. Is there any other way ? Thanks Raj
Hi Hui, Thanks a lot. I was trying to make it on my own but unable as I dont know VBA. I Thought that by using simple formula I can do so. Is there any other way ? Thanks Raj
Hui Excel Ninja Staff member Nov 14, 2014 #4 No But its very simple VBA You don't need to understand it too much
R rush2rajen Member Nov 14, 2014 #5 Hi Hui, Can you please help with the VBA. And whats the procedure to use and where the code should be written. Thanks Raj
Hi Hui, Can you please help with the VBA. And whats the procedure to use and where the code should be written. Thanks Raj
Hui Excel Ninja Staff member Nov 14, 2014 #6 Open the file I sent you, Enable Content & Macros if asked Press Alt+F11 Your now in VBA The code is in Click on Module 1 This module is what gets ran when you hover over the Arrows in Excel It sets a Named Range "velSelOption" to the name of the series eg: Pat, PBT etc To go back to Excel Alt+F11 You can copy / paste this code to another worksheet if required. There is also a Named Formula "valSelOption" which must be setup in the Name Manager valSelOption: =Sheet1!$O$8
Open the file I sent you, Enable Content & Macros if asked Press Alt+F11 Your now in VBA The code is in Click on Module 1 This module is what gets ran when you hover over the Arrows in Excel It sets a Named Range "velSelOption" to the name of the series eg: Pat, PBT etc To go back to Excel Alt+F11 You can copy / paste this code to another worksheet if required. There is also a Named Formula "valSelOption" which must be setup in the Name Manager valSelOption: =Sheet1!$O$8