Register time when cell entry last changed

March 10, 2010 at 07:33:31
Specs: Windows XP
Please advise if excel can have formula to register last change of another cell i.e. if cell A1 was retyped can cell A2 show date/time of that change ?

See More: Register time when cell entry last changed

Report •


#1
March 10, 2010 at 07:42:51
You can't do it with a formula, but you can do it with VBA.

Right click the Sheet Tab for the sheet you are working with and choose View Code.

Paste this into the pane that opens.

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

Each time a change is made to A1, the Time and Date in A2 will update.


Report •

#2
March 10, 2010 at 10:34:33
Thank you so much !

This was very helpfull and will save me some time when updating the price lists.

Thanks again and brgds


Report •

Related Solutions


Ask Question