Move right without using Enter, after typing one (1) character in cell

Hi.
I need to create an action on cells A1 to H1.
Can you type just one character in the cell and without pressing the ENTER key, move to the cell on the right side? this effect should run for cells A1 to H1.

Thank you!

Which character(s)?

Hi.

Only one (1) digit in cell

So if the user selects any cell in the range A1 thru H1 and then touches any of the keys {0 thru 9} then that key should be entered in the cell and the next cell should be selected??

Hi.

if I type any letter or number (since that is only 1 digit) in "A1" code vain move to "B1" it without using the Enter key and without using the TAB key.
and so on until "H1"

How has Excel or VBA to know, which value should be in which cell?

I don't think it's posible what you want.

Maybe you can use cel a1 for the input, and use VBA to divide it over the cells (a1 - h1)

cant see it myself,you need enter to let excel know that something has happened

The attached example is only for keys 0, 1, 2, 3

You will have to program the remaining keys yourself.
In a standard module enter:

Please Login or Register  to view this content.

In the worksheet code area, enter the following event macro:

Please Login or Register  to view this content.

The idea is to use OnKey to call the insert subs directly from keystrokes.

Hi.
thanks, but not that.

Even so your macro does not work.

I do not want to shake the Keypad Enter the code will do it for me.
Another thing, I want to type using any key on my keyboard, but only one key per cell without hit enter.

You are correct! For some reason, OnKeys does not detect a 1 from the numeric keypad, only a 1 from the second row of keys. I don't know why.

Hi.
anyone have any more ideas?
thank you

I found a way to make OnKey recognize the numeric keypad, but to really use my technique, you would need a separate macro for each key on the keyboard!

This is not practical.

Consider using some kind of UserForm.

Hi.
So I have to leave this topic, since there is no ways to solve it.

Thank you!

Hi.

is a hope that someone may try another way to do this?
Thank you!!

It may be possible with an event macro in a UserForm.

Hi.

you can send me an example?
Thank you!!

I will have to do some research. I am a novice at UserForms.