title: Worksheet_Change determine value not content
body: <p>I am trying to detect if there are changes in a cell value, not particularly the cell contents. I have found multiple solutions to find out if a cell contents has changed, but it does not work when a cell is equal to another cell. </p>
  
  <p>For example, I have cell A1 set to equal B1 and then B1 has a formula that calls in multiple other cells, so I am not able to go back to the beginning and determine whether the cell has changed from that. It needs to come directly from A1. </p>
  
  <p>This is one of the examples I found on this site, but does not determine if the value of A1 has changed, just whether the contents has changed.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Column = 1 Then
       Cells(Target.Row, 3).Value = Date
  End If
  
  End Sub
  </code></pre>