enter key

  • Thread starter Thread starter johnsail
  • Start date Start date
J

johnsail

What do you test for if enter key only has been used to move on to another
cell?
testing for "" only seems to work if "delete" has been used in the cell.

regards
 
I think you are going to have to provide more details about what it is you
want do.
 
What specifically do you want to test for? That the Enter key (as
opposed to, say, the mouse) was used to select the active cell? If
you're referring to worksheet events, Change is called with a cell
value is changed (by the user or by VBA, but not by calculation), and
SelectionChange is called when the user changes which cells are
selected (but there is no way to determine specifically how the cell
was selected).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top