What Cell Did I Come From? 1

[Elysium]

Has anyone seen how to capture which cell you are coming from in Excel? My example is such:

If I am in cell A1 and I click on cell D4, I want to be able to know that I was previously in cell A1. Anyone?

RS

 

[RobBroekhuis]

Use the selectionchange event:

rivate Sub Worksheet_SelectionChange(ByVal Target As Range)
Static Kilroy As String
MsgBox ("I was here: " & Kilroy)
Kilroy = Target.Address
End Sub
Rob

 

[RobBroekhuis]

That's Private, of course ;-)
Rob

 

[Elysium]

Thank you, thank you!! Works like a charm.

RS