Last Modified UDF Row Function

[mdonovan890]

I do not know if this is possible however, what I am looking for is to modify this UDF function to show the date that a cell was last modified. Currently, it is only showing the date that the UDF is inserted, not the actual date that the cell was modified.


For Example:

-If I am insert the UDF Function on 5/3/20

-A Cell Modified on 4/13/20

-The UDF Should return 4/13/20, NOT 5/3/20.


Current UDF Function:
Public Function Lastmodified(c As Range)

Lastmodified = Now()

End Function

 

[Yongle]

4/13/20 is BEFORE you entered the function - Excel does not remember when a cell was modified

The function works correctly for amendments to the cell made AFTER the function is entered

 

[mdonovan890]

4/13/20 is BEFORE you entered the function - Excel does not remember when a cell was modified

The function works correctly for amendments to the cell made AFTER the function is entered

Hi Yongle,
Yes, that is correct. Is there a way via UDF or VBA to obtain the last modified date prior to the function being entered?

 

[Yongle]

it is not possible at individual cell level
it is possible to get the last modified date for a workbook