title: Run a VBA code from changing the value of a cell in another spreadsheet with a combo box
body: <p>Saw this question was never completely answered in similar posts so I'll try again.  Starting from a blank workbook I would like to have a drop down list on "Sheet1" but with the input range on "Sheet2!$A$1:$A$4" and the Cell Link on "Sheet2!$H$5"</p>
  
  <p>When a user selects an option from the dropdown list in Sheet1, the value in Sheet2 should change and that should start the macro.   However, I was only able to get a macro to work if Sheet2 was the active sheet.  Is there a code that can execute if it detects changes in a different sheet?  Question 2, do I put the code in "ThisWorkbook" or "Sheet1"?</p>
  
  <p>Keypoints:  Macro caused by a change in a cell in a non-active worksheet.</p>
  
  <p>Thanks!
  Art</p>