Date and Time stamp when any part of worksheet is changed

[Woodpusher147]

Hi All
Really sorry if this has been answered (I feel like it mustve been) however, I have been searching both here and google for the last hour trying to find but no luck.

All I need is a single cell to show date and time of last update to any part of the worksheet

So B12 shows date/time last update to sheet

Thanks for any help

 

[Woodpusher147]

Apologies as this seems to be quite simple.
I was searching for last updated and it is of course last modified

I used this code
Function LastModified() As Date

LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

End Function

and then simply added to required cell =LastModified()

Thanks