Cell Lost Focus

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Is there a "lost focus" or change event in Excel? I want
to launch some code when a user exits a particular cell.

I have looked at the other similar questions in this
particular newsgroup and they are not helpful. Any
additional insights would be greatly appreciated.

Thanks.
 
use the default sheet's SelectionChange event. the parameter is the new
cell's address, however, if you save this into a public variable, it will
become the moved from cell at the next change. Just set up the open event to
select say A1 which will fire the event & populate the variable

Example:copy this code to the active sheet's code page:

Option Explicit
Public LastCell As String
Private Sub Worksheet_Deactivate()
Application.StatusBar = False
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = "FROM:" & LastCell & " TO" & Target.Address
LastCell = Target.Address
End Sub
 
Back
Top