Excel/VBA update cell every time value in another cell changes
<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>