ExcelBanter - Can I detect a KEYDOWN event while in a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can I detect a KEYDOWN event while in a worksheet (https://www.excelbanter.com/excel-programming/348162-can-i-detect-keydown-event-while-worksheet.html)

Ken Soenen

Can I detect a KEYDOWN event while in a worksheet

Is there a way I can detect a keydown(or up or pressed) event while I'm
working on a worksheet(not on a Form) and then call a Macro if it is a
specific key?

thanks,
ken

Jim Thomlinson[_4_]

Can I detect a KEYDOWN event while in a worksheet

Nope. No events are triggered while you are editing a cell.
--
HTH...

Jim Thomlinson

"Ken Soenen" wrote:

Is there a way I can detect a keydown(or up or pressed) event while I'm
working on a worksheet(not on a Form) and then call a Macro if it is a
specific key?

thanks,
ken

All times are GMT +1. The time now is 03:05 PM.