Prevent Selection Change

[music_al]

Hi

I want to prevent the SelectionChange procedure from running if the user pressed the TAB or RETURN key to get to the cell. How do I check for the last key pressed ?

Thank you in advance.

Al

 

[DanteAmor]

Check this

https://docs.microsoft.com/en-us/office/vba/api/excel.application.onkey


Examples:
https://www.mrexcel.com/forum/excel-questions/77014-onkey.html

https://www.mrexcel.com/forum/excel-questions/747258-onkey-event-not-working.html

https://www.mrexcel.com/forum/excel-questions/867629-application-onkey.html