title: Excel/VBA update cell every time value in another cell changes
body: <p>I'm very new to VBA. I have a cell in the worksheet that live updates a value. the Value changes about once every month. Is there a way for me to record the day that the value changed in an adjacent cell? 
  For example,
  If the value in A1 changes from 5 to 6 today, I just want to record today's date in A2.</p>
  
  <p>I don't really need to keep a record of previous changes. </p>
  
  <p>Thank you so much!</p>