Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Showing last editing date
I was wondering if there is a way to have one cell show the date of when
another cell was last edited. |
#2
|
|||
|
|||
You can use a change event. Assume you want cell B1 to track when last A1 was
changed. Right click sheet tab, select View Code and paste the macro below: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Application.EnableEvents = False If Target.Address = "$A$1" Then Range("B1").Value = Date End If ErrorHandler: Application.EnableEvents = True End Sub Hope this helps Rowan "Kenny" wrote: I was wondering if there is a way to have one cell show the date of when another cell was last edited. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Showing date last saved | Excel Discussion (Misc queries) | |||
date and time | New Users to Excel |