golf data validation

[caseyg]

I'm attempting to enter golf hole scores (range from 1 to 15) and would like a method to have the active cell to move one to the right for each valid entry.
So, if I enter 2 through 9 the cell to the right is activated, zero is ignored as the first entry, and two digit entries starting with 1 (10 to 15) also activate the cell to the right. 1 (a hole-in-one) would be a special case requiring a manual tab.
I'm guessing vba is the way to go but have no idea where to start.

Thanks

 

[Gerald Higgins]

Hi, welcome to the board.

There are two things you can do here.

First of all, use Data Validation to limit entries to the ones you want, such as 1-15, or whatever.

Second, on the Tools, Options, Edit tab, tick the box for Move after Selection, and specify RIGHT as the direction.

What may also help with this is using protection.
By default, all cells on the worksheet are locked, but this has no effect until you turn protection on.
So, use Format, Cells, Protection, to UNLOCK the cells where you input the scores, and then turn on workSHEET protection, and UNtick the box to "Select unlocked cells".
This will make the cursor jump from one unlocked cell to the next.
For example, if you have a 3x3 table for inputting data in the range A1:C3, when you get to A3 and press enter, the cursor will jump to B1.