action on lostfocus in a cell
Hi to all
This is a step in correct direction.
Try this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static oldRange As Range
If Not oldRange Is Nothing Then
If oldRange.Address = "$M$3" Then
MsgBox "Do your stuff"
End If
End If
Set oldRange = Target
End Sub
Hoop that helps,
Wouter
|