• Hi guys, you know any code to generate automatically the date of modification of one cell?

  • Add the date into a cell comment like this

    Sub DateModified()
        On Error Resume Next
        With ActiveCell
            On Error GoTo 0
            .Comment.Text Text:="Modified on: " & Format(Date, "long date")
            .Comment.Visible = False
        End With
    End Sub

    If you want it to be automatic then you could use a worksheet event

    If you aren't sure how to use event code then read this

    Where to put the code

  • So good your code, its work, how can I make it work only in the column O?

  • Try this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!