VBA Time stamp based on formula value change

[rvalizan]

Hello,

I have looked everywhere I feel like for a solution to my problem. I have never worked with VBA before, and am having trouble finding a solution for my problem.

I have a range of cells, "D:F", in which I need a time stamp to be placed in column "I" on the event of any of the formula values changing in any of those range of cells.

I was able to get a change event to work, but not the way I want. I cannot figure out how to properly set up a calculation event.

I tried this solution but it has syntax errors and is not working. Maybe you can kind of see what i'm trying to do here.

Private Sub Worksheet_Calculate()Static OldVal()
    If Target, Range("f:f") <> OldVal() Then
        Cells(Target.Row, 9) = Date
        OldVal() = Range("F:F").Value
    End If
End Sub

Thank you ahead of time for any solutions you may be able to provide me.