change cell event using circular reference

  • Thread starter Thread starter Dan
  • Start date Start date
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
 
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"
 

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

change cell event using circular reference - not VBA! 3
countifs Function not giving desired result with date criteria 2
Circular reference, Indirect, and Sum 3
want to track time while paste value in multiple column of same roe 1
Recalculating in a circular reference 3
Excel Conditional Formatting 1
a cell contain formula, how to extract value of that cell 1
if statement, change cell only if true 4

Back
Top