Thank you.
I have two columns, say C & D.
if user enters in D and C is empty, I display a message and move the active
cell in C (same row). when user enters a value in C and then enters in D and
hit RETURN key, I don't want to display the message, simply move to next row
C.

how to find I hit RETURN?
or the previous cell is in D?

is there any way to display a tool tip when user moves to column D with
empty C?

Thanks
MVM

"Frank Kabel" wrote:

Hi
one brute-force way would be to use the SelectionChange event to store the
old active cell in a static variable. what are you trying to do with this
information

--
Regards
Frank Kabel
Frankfurt, Germany
"MVM" schrieb im Newsbeitrag
...
How to find the location of the previous activecell?
Appreciate the help.
MVM