automatically advance to next cell without hitting enter or tab

does anyone know of a way to have Excel move automatically to the next
cell after entering one digit (without hitting enter every time?)

If there is some sort of script or something that anyone is aware of
that already exists that I would need, can you please point me to it
and tell me how to set it up?

Hi
AFAIK this is not possible as you can't run macros while in Edit mode

--
Regards
Frank Kabel
Frankfurt, Germany


corby wrote:
does anyone know of a way to have Excel move automatically to the
next
cell after entering one digit (without hitting enter every time?)

If there is some sort of script or something that anyone is aware of
that already exists that I would need, can you please point me to it
and tell me how to set it up?

Excel doesn't know you have entered anything until you touch the enter or an
arrow key or the tab key.

--
Don Guillett
SalesAid Software

"corby" wrote in message
...
does anyone know of a way to have Excel move automatically to the next
cell after entering one digit (without hitting enter every time?)

If there is some sort of script or something that anyone is aware of
that already exists that I would need, can you please point me to it
and tell me how to set it up?

You could use a small userform that only accepts one character.

Here's an example to get just a single digit:
http://groups.google.com/groups?thre...7D33%40msn.com

corby wrote:

does anyone know of a way to have Excel move automatically to the next
cell after entering one digit (without hitting enter every time?)

If there is some sort of script or something that anyone is aware of
that already exists that I would need, can you please point me to it
and tell me how to set it up?

--

Dave Peterson

Never say never. Check http://groups.google.com/groups?threadm=
4085DF50.CA7B7D33%40msn.com for one way to do what you want

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
does anyone know of a way to have Excel move automatically to the next
cell after entering one digit (without hitting enter every time?)

If there is some sort of script or something that anyone is aware of
that already exists that I would need, can you please point me to it
and tell me how to set it up?