View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
 
Posts: 117
Default Get excel to automatically go to the next cell w/o pressing enter

If you plan to always enter the same number of characters in a cell, it
could be done. Otherwise, you will have problems. For example, what if you
want to type 25 in a cell? You type the "2" and the subroutine moves you to
the next cell because you've entered something and you're never allowed to
enter the "5" to complete "25". The Enter key is how you tell the
application you're through typing in the data for that cell. Explain the
type data you're entering and someone might have some options for you.

Steve



"AMR" wrote in message
...
After I enter something in a cell I would like the selected cell to move
to
the next cell without having to press enter. Is this possible? If so, how
do
I do it?