action on lostfocus in a cell
"Executor" skrev i en meddelelse
oups.com...
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
Exatly what I needed - after I discovered that it not was in module, but
in
sheet (ark in danish) I should put it.
Tnx
|