Hi Guys!
I have a table in which the A column indicate the status of a task and the other columns are information regarding that task. I want to have a column (K) that indicates the last time the A cell of the same row as been modified. All data is inputted using a userform, which means the formula in the K cells must be inputted automatically and refer to the A cell of the same row.
Everything works for the data input and the K cell value do change when the A cell value changes(I was using a timestamps with minutes when I tested), however for some reason the dates seems to be updated daily ; when I opened the workbook this morning, all dates were today's -_-
Here is what I've done so far ;
1) Create a function that generate the date if the reference change
2) Defined the value of the K Cell in the userform VBA ("État" is the name of the A column header)
Thank you for your time!
I have a table in which the A column indicate the status of a task and the other columns are information regarding that task. I want to have a column (K) that indicates the last time the A cell of the same row as been modified. All data is inputted using a userform, which means the formula in the K cells must be inputted automatically and refer to the A cell of the same row.
Everything works for the data input and the K cell value do change when the A cell value changes(I was using a timestamps with minutes when I tested), however for some reason the dates seems to be updated daily ; when I opened the workbook this morning, all dates were today's -_-
Here is what I've done so far ;
1) Create a function that generate the date if the reference change
VBA Code:
Function Timestamp(Reference As Range)
If Reference.Value <> "" Then
Timestamp = Format(Now, "dd-mm-yyyy")
Else
Timestamp = ""
End If
End Function2) Defined the value of the K Cell in the userform VBA ("État" is the name of the A column header)
VBA Code:
.Cells(iRow, 11).Value = "=Timestamp([@État])"Thank you for your time!
