Differentiate keypresses in Worksheet_SelectionChange event

**Mervil** · 12-07-2010, 01:49 AM

I have several pieces of code setup in a Worksheet_SelectionChange event. I've run into a situation where I must be able to have the event track whether a cell was entered by using either the enter key or the down arrow. I'm not sure if this is even possible. Unfortunately, there is no such thing as a Worksheet_KeyUp event.
I would greatly appreciate any ideas.

Thank you!

**romperstomper** · 12-07-2010, 04:12 AM

First things I have to ask are:
1. Why?
2. What if the user selects a cell with the mouse?

**Mervil** · 12-07-2010, 06:09 PM

1) I have text boxes placed on my worksheet and code in place to activate the text boxes when worksheet-selectionchange event detects when certain cells are selected. Code is also in place to prevent entry and immediate exit when the enter key is pressed to enter the txt box.
2) mouse clicks pose no problems so far.

**romperstomper** · 12-08-2010, 03:59 AM

Well, the only thing I can think of would be to set a low level keyboard hook using the Windows API, as it's the only way (other than timers, which don't make sense here) to be able to run code while in edit mode, which you need to do to trap the user entering data and switching cells when pressing enter or tab or an arrow key. Not for the faint hearted though since if it goes wrong it will likely crash your application completely.
For the record, it sounds to me as though you would be better off with a userform (or a database app).