Is it possible to detect which key the user pressed when entering a
cell value? Did they enter the value by pressing enter (return on Mac),
tab, any of the arrow keys or the Numpad enter key?
I want XL to check that the entered value is not greater than the value
in row 4 of the same column without using data validation.
The code I'm presently using is in the Workbook_SheetChange Event
Procedure but it only works properly when the user presses a key which
selects the cell directly below (or uses the mouse to directly select
that cell).
I want to change the code to cover instances where the user uses tab,
up arrow, left arrow, right arrow or enter on the Numpad to enter a
cell value. To do this I need to determine the key pressed by the user.
Any help will be much appreciated.
Ken Johnson