Run Macro On Active sheet when attempting to switch sheets

[BIGTONE559]

Is there an event than can be used to run a macro when a user attempts to switch pages?

I currently have a code but when i change sheets it runs on the active sheet when i would want it to run on the sheet that I switched from. . .

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)

If IsEmpty(Range("J1")) Then
MsgBox ("Please Check the Date Prior to Switching Pages")
End If



End Sub

 

[BIGTONE559]

I kinda solved this one myself so i'm posting results so that it may help someone.

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object) 
if isempty(Worksheets(Activesheet.index-1).Range("J1)) then

MsgBox ("Please Check the Date Prior to Switching Pages")
End If    
End Sub