Thread: Cell Lost Focus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_4_] Patrick Molloy[_4_] is offline
external usenet poster
 
Posts: 103
Default Cell Lost Focus

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
--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Craig" wrote in message
...
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.