Search results

Thanks Hui, works a treat. I initially used the change event code to have some functionality in the dashboard, until I better understood how to incorporate the selectionchange. Thanks again!

I've uploaded an example file here https://www.dropbox.com/s/ujjrdw2e76oksqm/Example.xlsm This file runs off my original code, as you can see, rngStructure provides valSelItem1 with a value according to user selection. rnStructure2 only fires on worksheet_change given thats what I'm using at...

The below macro allows users to select a cell from the named range "rngStructure" and produce a value in "valSelItem". This value I use to dynamically drive a dashboard. I now need to expand this dashboard to include a 2nd variable (output) "valSelItem2" from a 2nd range "rngStructure2"...