change cell event using circular reference
 

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

change cell event using circular reference
 

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

"Dan" wrote:

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

change cell event using circular reference
 

On Jun 17, 1:12*pm, Dan wrote:
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

change cell event using circular reference
 

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"

"Nayab" wrote:

On Jun 17, 1:12 pm, Dan wrote:
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