automatically advance to next cell without hitting enter or tab

[corby]

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?

 

[Frank Kabel]

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

 

[Don Guillett]

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

 

[Dave Peterson]

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/[email protected]

 

[Tushar Mehta]

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