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.

--
Rick (MVP - Excel)


"johnsail" wrote in message
...
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

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)

On Sun, 6 Sep 2009 04:49:01 -0700, john sail
wrote:

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