title: VBA - Get OLD Value of Combobox
body: <p>I would like to get the old value of a ComboBox when the combobox value will change.</p>
  
  <p>I have tried something like:</p>
  
  <pre><code>Private Sub ComboBox1_Change()
          Application.EnableEvents = False
          newVal = ComboBox1.Value
          Application.Undo
          oldVal = ComboBox1.Valu
  End Sub
  </code></pre>
  
  <p>or</p>
  
  <pre><code>Private Sub ComboBox1_Change()
          Application.EnableEvents = False
          newVal = ComboBox1.Value
          ComboBox1.Undo
          oldVal = ComboBox1.Valu
  End Sub
  </code></pre>
  
  <p>but it seems not to work...</p>
  
  <p>Thanks</p>