AUTOMATIC DATE

  • 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


    Code
    Sub DateModified()
        On Error Resume Next
        With ActiveCell
            .ClearComments
            On Error GoTo 0
            .AddComment
            .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!