VBA to run a macro when leaving a specific active cell.

[EssKayKay]

I’m not positive this is going to do exactly what I want but I’d like to start here.

I’m looking for a routine that runs after leaving a specific cell (K7). That is – when the active cell is K7, and I click on some other cell or even hit enter (because K7 is no longer active) I want to run a macro. I only want this to run when leaving K7 and not run any other time.

Thanks for viewing,
Steve K.

 

[Joe4]

Right-click on the sheet tab name at the bottom of the screen, select View Code, and paste this VBA code in the VB Editor that pops up:

Public cellAddress As String


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'   See if previous cell selected was K7
    If cellAddress = "$K$7" Then
        'Call Macro here
    End If
    
'   Set cell address for next run
    cellAddress = ActiveCell.Address
    
End Sub

Replace the

'Call Macro here

part with the name of the code you want to run.

Now, as select cell K7 and then you move off of cell K7, it should run your code.

 

[EssKayKay]

Thank you very much Joe. This is what I was looking for. Now let me see if I can get this to do what I have in mind.

Again, much appreciated,
Steve

 

[Joe4]

You are welcome.
Glad I was able to help!