change cell event using circular reference

[Dan]

Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

 

[Mike H]

Hi,

Right click your sheet tab, view code and paste this in

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub

If Not Intersect(Target, Range("A2")) Is Nothing Then

Target.Offset(, 1).Value = Time

End If

End Sub

 

[Nayab]

Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

Dan, u can get some help at http://www.mvps.org/dmcritchie/excel/event.htm#autodate

 

[Dan]

Thank you all, but I am looking for a formula not vba - this is why I have
put in my subject "circular reference" and also poseted it in the "Excel
Worksheet Functions" and not "Excel programming"