Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Column = 15 Or Target.Column = 16) And Target.Count = 1 Then
On Error Resume Next
Target.AddComment
Target.Comment.Text Text:=CStr(Now)
Target.Comment.Shape.TextFrame.AutoSize = True
On Error GoTo 0
End If
End Sub