title: Using VBA how do I detect when any value in a worksheet changes?
body: <p>I have a worksheet that contains a few columns with hundreds of values. I want cell A1 to say "Value Changed" as soon as any value changes in the worksheet. I tried to make some code like what you see below, but I couldn't think of how to capture the original value in the OriginalValue variable. How can I detect when the value in any cell changes from something that is different than the Target value?</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Value &lt;&gt; OriginalValue Then
      Range("A1").Value = "Value Change"
  End If
  
  End Sub
  </code></pre>