Move selection if cell contains 1 numeric char

[Zaeguzah]

Hey guys. I'm back with new challenge for you. Hope you can help me out.

Let's consider the folowing workbook:

A B C D E F G H I J K L

In the same row in each column I need to add exactly one number from 0 to 9. I want to type in column A a number and automatically move the selection box one column further until col L is filled. Could this be done in VBA? And if not, is there any alternative?

[JBeaucaire]

You can get this behavior by simply selecting the cells A2:L10 before you start typing. As you begin entering numbers in the highlighted range, the cursor will move across through the selected range, then down to the next row until it reaches the end of your selection range, then it will start over. No VBA needed.

[Zaeguzah]

Thanks for the reply JB but that is not exacly what I'm looking for. We have lots of data to insert. And using your suggestion, we would have to press enter each time we need to change the column. Plus, this won't block the max 1-char insertion in those cells.

[JBeaucaire]

Ah, one digit per cell. Ok.

Select a cell and run this macro.

Please Login or Register  to view this content.

[Zaeguzah]

Thanks JB! This exactly what I needed. I'm sorry I didn't reply earlier but I was extremely busy and just couldn't find the time. Thanks so much for your time and effort. SOLVED