View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default detecting keypress(es) in a cell

There's a worksheet_Change event that may do what you want.

If you want to read more about events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

Hernan wrote:

hmmm...

how about on "exiting" the cell?

"Tom Ogilvy" wrote:

If the user is editing a cell, then for any practical purpose, macros don't
run.

--
Regards,
Tom Ogilvy

"Hernan" wrote in message
...
As per subject... is there a way to do this?

I would like to detect the Enter key code and SHIFT+Enter keys

combination.

TIA

Hernan.





--

Dave Peterson