Last Modified Date & Last Modified Time in a cell

[Thanseef M S]

how to generate Last Modified Date & Last Modified Time in a cell

 

[Herakles]

Do you want this to be the exact time that you made the last change to any cell in each worksheet in the workbook, the last time that you made any change to any cell in any worksheet in the workbook or the last time that the workbook was saved?

 

[Thanseef M S]

Do you want this to be the exact time that you made the last change to any cell in each worksheet in the workbook, the last time that you made any change to any cell in any worksheet in the workbook or the last time that the workbook was saved?

in a specified cell like this...

Last Modified Date	answer
Last Modified Time	answer

 

[Herakles]

Assume that you want to store the date and time in cells B1 and B2 of the 'datetimelog' worksheet and set the formula in these cells to '=NOW()'
and the number format to 'dd/mm/yyyy' and 'hh:mm:ss' respectively.

Copy the folowing code to the ThisWorkbook code module.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    
    Worksheets("datetimelog").Range("B1:B2").Calculate

End Sub