Audrey

Until you hit Enter or Tab or an arrow key Excel has no way of knowing that you
are finished typing in that cell.

You must indicate in some way that you are ready to go to next cell.

Data Validation only shows a message after you have left the cell.

Event code still requires you to leave the cell before it triggers.


Gord Dibben MS Excel MVP

On Sun, 30 Jul 2006 01:27:01 -0700, audrey
wrote:

Thanks for your answer. I tried it and it solved part of my problem, but I
should probably rephrase my questions b/c I just realized it wasn't very
clear. What I idealy would like is for my cursor or I guess the selection to
automatically move down to the next cell after I've finished typing in one so
that I don't have to hit Enter each time, which adds 600 extra keystrokes to
the other keystrokes I'm already making (I have to do this set 250 times). I
figured that if I could assign a character length to the cells, it would
eliminate the use of the Enter key, but that wasn't the case. I also tried
setting up a macro to no avail.

I basically want to type the numbers 1212122212221221221112 etc, each in its
own cell without hitting enter so the process goes much quicker.

I hope that makes more sense.

Audrey

"VBA Noob" wrote:


Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361