Show last date a cell was modified

AlexSrois

New Member
Joined
Aug 14, 2021
Messages
15
Office Version
  1. 2016
Platform
  1. Windows
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

VBA Code:
Function Timestamp(Reference As Range)
If Reference.Value <> "" Then
Timestamp = Format(Now, "dd-mm-yyyy")
Else
Timestamp = ""
End If
End Function

2) 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!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,148,241
Messages
5,745,583
Members
423,963
Latest member
lwilson3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top