View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkB MarkB is offline
external usenet poster
 
Posts: 21
Default Determine if Carriage Return or Tab key is used

I need to show a message box if the user enters an "N" in any particular
cell. I currently have code in the SelectionChange procedure, which checks to
see if the cell direcly above or to the left of the active cell has the "N".
This causes a problem because if a user is entering information on the next
line, when the active cell is direcly below a cell with only an "N", it shows
the message box. So, I am wanting to write a procedure that is triggered when
the user hits either Enter or Tab to check if the last active cell has only
an "N".

Please help if you can.

Thanks,
--
Markb