• 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.

Search results

  1. C

    Excel VBA - Worksheet_Selectionchange for 2 ranges and outputs

    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!
  2. C

    Excel VBA - Worksheet_Selectionchange for 2 ranges and outputs

    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...
  3. C

    Excel VBA - Worksheet_Selectionchange for 2 ranges and outputs

    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"...
Back
Top