Run macro based on previously selected cell

[EssKayKay]

Hello,

I’m looking for a VBA routine to run a macro if the previous selected cell was “K7”. I may be wrong but I assume this code will be placed in the Worksheet_SelectionChange subroutine. Any suggestions would be appreciated.

Thanks for viewing,
Steve K.

 

[Micron]

Sadly, there doesn't seem to be a "BeforeSelectionChange" event, so yes, SelectionChange would be the only one you could use. However, this event will not tell you what cell was active, but will only tell you what your selection became. You could set a module level variable in a standard module to the cell address at the end of this event, but that will only happen after the first selection change. To get around that, you'd probably have to get the active cell address when the workbook opens in order to have a starting address at that time. If that happens to be K7, then what?

However, the active cell pertains to the active sheet, so if you're wanting to work with Sheet2 but the wb opens and Sheet1 happens to be the active sheet, and K7 is the active cell, then that could be a problem. If the sheet name matters you'd need to incorporate the sheet name into the variable as well. I guess I'm rambling a bit because you didn't say if it was one sheet or every sheet that you want this to work for. Hopefully you get my drift.

 

[EssKayKay]

Thank you Micron for your insight. I will probably just leave things as is.
Steve