Detecting last key pressed in Excel

[ssmgr]

Can anyone tell me how I can tell when the last key pressed was the Delete key in Excel?

I can work out when a change has occurred and when a selection has changed via Worksheet_Change and Worksheet_SelectionChange, and can deduce which cell I was in before if the last key was the enter key, however I can't detect the delete key. Any advice appreciated.

Steve

 

[PHV]

Provided you write your own delete routine you may consider the Application.OnKey method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ssmgr]

Thanks for that PH. Your blood's worth bottling.