Hi All,

I am currently using the following code to add a timestamped cell comment to certain cells on a spreadsheet, to highlight when data was inserted into those particular cells...

Private Sub Worksheet_Change(ByVal Target As Range)
    For Each c In Target
        c.ClearComments
        If c.Value > 0 And c.Column > 9 Then
            c.AddComment Application.WorksheetFunction.Text(Now, "dd/mm/yyyy HH:mm")
        End If
    Next c
End Sub
I would like to know if there is any way of achieving the same result, without the use of a macro?

Thanks,