Mastering Development

How to make the value of a cell change when the date is updated?

In cell "S1" I have the formula that brings today.

I need that when this formula is updated, the value of cell "T3" automatically returns to 0.

In the codes I tested, it works only if I change the value manually, but I need it to happen automatically.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Me.Range("S1")) Is Nothing Then
Range("T3").Value = 0
End If

End Sub

The code above occurs when I change the date of cell S1 manually, but that’s not what I’m looking for, so I know I need to do this in the Worksheet Calculate event, but I don’t know the code.

Leave a Reply

Your email address will not be published. Required fields are marked *