title: Changing Value of one drop down list when user makes a change in another drop down list
body: <p>In Excel, I would like the displayed/selected value of a Drop Down List to change when a user selects an item from another Drop Down List.  (I can already change the options in the list)</p>
  
  <h2>Background:</h2>
  
  <p><code>List1</code> is a drop-down list with the following available entries:</p>
  
  <pre><code>Product1                     
  Product2                   
  </code></pre>
  
  <p><code>List2</code> is a drop-down list with the following available entries (these are payment periods):</p>
  
  <pre><code>6  (available for Product1 and Product2)
  10 (available for Product1 and Product2)
  3  (available for Product2)
  16 (available for Product2)
  20 (available for Product2)
  </code></pre>
  
  <p>So far, I have managed to update the available drop-down entries in <code>List2</code> when the selected item in <code>List1</code> changes. But it is only the drop-down entries which change; the actual currently visible content of <code>List2</code> does not change.</p>
  
  <h2>Issue:</h2>
  
  <p>This is not yet what I would like: As soon as the selected item in <code>List1</code> changes, <code>List2</code> should immediately display "Please Select" (in addition to <code>List2's</code> available drop-down entries being updated), so a user is aware that a selection must be made in <code>List2</code>.</p>