SheetSelectionChange Event find out previosly selected cell

[Anton Sommer]

Hello folks,

when the selection has changed in the grid the Event SheetSelectionChange is
thrown. Is there a possibility to tell what cell was previosly selected?


Thanks,


Anton

 

[Earl Kiosterud]

Anton,

You can keep track of it yourself:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static OldCell As Range
If Not OldCell Is Nothing Then ' not first time
MsgBox "The old cell is " & OldCell.Address _
& "And it contained " & OldCell
End If

Set OldCell = Target
End Sub


Your code goes where the MsgBox line is. You use the OldCell object as a
range. It's the previous cell.

 

[Earl Kiosterud]

Anton,

It occurs to me that the old multiple-cell selection would confound this.
You might want to change the last line to:

Set OldCell = ActiveCell

Earl Kiosterud
www.smokeylake.com

 

[Anton Sommer]

Thanks Earl,

that should solve my problems

Anton