Timestamp with a drop down list

  • Hi everyone

    Im novice with excel and vba

    I made a workbook with 2 sheets, in one sheet I got a table with drop down list In 3 columns (f ,h ,j)

    I am looking for a vba code that create a timestamp when a drop down list is changing

    The time stamp will be in the next column ( if f is changing the timestamp will be in g….)

    I couldn’t figure it out on my own

    Can anyone help me please???:


  • Have a try with my macro to be pasted in the sheet's module (the one with the dropdowns) and change the date format of the time-stamp if necessary:

    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
        Application.EnableEvents = False
        If (Target.Column = 6 Or Target.Column = 8 Or Target.Column = 10) Then Target.Offset(0, 1) = Format(Now, "mm/dd/yyyy hh:mm:ss")
        Application.EnableEvents = True
    End Sub

Participate now!

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