Inserting Date/Time of Last Update

  • Thread starter Thread starter Lionel B. Dyck
  • Start date Start date
L

Lionel B. Dyck

Is there a way to insert a date and time in a cell(s) that will only be updated
if there is a change to the worksheet. I'm looking to have the date/time of the
last update so that it is easy to tell how current the worksheet is.

Thanks
 
Lionel

You could put some code in a worksheet_Change() event like so (uses A1)

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A1").Value = Now()
End Sub

To implement right click the sheet tab and select view code and paste in
window and save

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
Thank you for both suggestions - I'll give them a try.

Much appreciated
 
You must log in or register to reply here.

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

Auto date update 1
Date recalculates 1
Update: Date 1
VBA - retrieve data on last create named range from previous inserted named range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
show date of last update... 1
Auto Input Today's Date 3
return date format in function 4

Back
Top