H
hanjohn
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
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