View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Executor Executor is offline
external usenet poster
 
Posts: 74
Default 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