VB to Determine cell is selected

[Rocky0201]

In my VB module for ny worksheet, I have a sub BeforeDoubleClick and a sub Change. These both work great...

Is there an event that would trigger if the user just clicks on any cell? I tried to use Activate but that only works if I click on the worksheet tab from another worksheet.

My goal is to save pertainant information from K4 before K4 is changed or the user double clicks K4.

My problem is that once the BeforeDoubleClick or Change subs are used, that data has already changed in K4.

Thanks

 

[VoG]

You need a third event procedure

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(False, False) = "K4" Then
'
'do your stuff
'
End If
End Sub