How do I capture the keydown event in a worksheet?

[Lost In Excel]

I don't see the event in the dropdown in my VBA project sheet object

 

[Dick Kusleika]

LIE

There is no keydown event for worksheet objects. Macros won't run when a
cell is in "Edit Mode" so the event wouldn't do you any good anyway. You
might consider the Worksheet_Change event. If you really need a keydown,
you will probably have to put a textbox over the cell and use the keydown
for that. It's a lot of work though.