How should I set Excel to automative move to the next cell without press "Right Key" when I input on

[KevinZhao]

Hello, everyone:
I hope to input just one charactor in one cell, and when I input
it, I hope Excel can automative move to the next cell without press
"Right Key", so that I can continue to input the other charactor in
the next cell. How can I set Excel to do it?

 

[Frank Kabel]

Hi
this is not really possible. Though you may check the
onkye status with API cals this kind of solution won't be
stable (IMHO). Problem is Excel does not execute macros
while in Edit mode.

 

[Dave Peterson]

One way is to make a small userform that only accepts a single character.

Here's an example to get just a single digit:
http://groups.google.com/[email protected]