[SOLVED] How to enter single char data into Excel worksheet without hitting Enter

Hi

I am looking for a way to enable fast data entry whereby a single character (between 0 and 9) is entered into a cell and the cursor then moves to the adjacent cell without having to hit Enter or Tab. I looked at Data Forms but those require a tab to move to the next field. I tried Worksheet Change Event but it still requires me to hit Enter after typing in the single character into the current cell to get to the adjacent cell.

Each record has about 30 cells line up horizontally and each cell contains a single character between 0 and 9. There are a thousand records in one worksheet that require similar data entry hence having the capability I just described will make life a lot easier for the data entry folks.

Any help or suggestion is much appreciated.

Phil

To do this you would possibly be best to use the Worksheet Change Event and data validation

Right click on the sheet tab and select > View code and paste all of this code in the resultant window.

Please Login or Register  to view this content.

Then Select your range to validate in this example A2:A75

Data validation > List

Source 1,2,3,4,5,6,7,8,9

Try the demo workbook select from the drop-down in column A

Hope this helps

Here's another way.

In the Sheet module:

Please Login or Register  to view this content.

In a code module:

Please Login or Register  to view this content.