automatically show modified date?

  • Thread starter Thread starter Tacrier
  • Start date Start date
T

Tacrier

When I save changes to my current worksheet, is it possible have a formula in
A2 to display today's date (based on the condition that changes were saved to
the current worksheet)?

A1 contents:
"Information on this worksheet was last updated on:"

A2: "today's date" (if in fact "today", changes were made and saved)

Thanks!! :)
 
Hi

Try something like this. You copy the code to ThisWorkbook in VBA.


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Worksheets("name of the sheet").Range("cell address").Value = Date

End Sub


Change the sheet and range.
 
Awesome. Thank you!! :)

Wigi said:
Hi

Try something like this. You copy the code to ThisWorkbook in VBA.


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Worksheets("name of the sheet").Range("cell address").Value = Date

End Sub


Change the sheet and range.
Click to expand...
 
Back
Top