Updated times stamp of last change

  • Thread starter Thread starter rciolkosz
  • Start date Start date
R

rciolkosz

I have a shared excel file. How do I display a time stamp of what time the
latest change was made?
 
Several ways to do this.

Event code can be tailored to suit your needs.

Where would you like to see the timestamp?

On one sheet or on all sheets?

This sheet event code would give you a timestamp in B1 whenever A1 was changed.

I'm sure you have something more complex in mind, but example only..

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Target.Offset(0, 1).Value = Now()
End If
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Last Record 5
Creating custom stamps in .pdf Adobe documents 1
Date stamp user 7
how do I put a date/time stamp in comments? 2
Adobe Acrobat Stamp 0
time stamp question 2
Date Stamp in Footer 1
Time stamp 3

Back
Top