Having the cursor automatically move to the cell to the right

**bobbby1949** · 07-08-2010, 10:11 AM

Still working on the golf club's worksheet. How do I have the cursor move to the cell on the right after entering a number? Is there a conditional formatting formula for that process.

**martindwilson** · 07-08-2010, 10:43 AM

you can do it in excels options

**bobbby1949** · 07-08-2010, 11:21 AM

Martin, I have browsed through the Excel Options several times and unable to locate a way to move the cursor without hitting the arrow or enter keys. I am using 2007 version. Thanks for the help.

**shg** · 07-08-2010, 12:33 PM

How do I have the cursor move to the cell on the right after entering a number?

unable to locate a way to move the cursor without hitting the arrow or enter keys.

The way you enter a number (or anything else other than an array formula) is to hit the Enter key. The only way to could do what I think you want is to use a form, textboxes, and code, which is major overkill.

**MarvinP** · 07-23-2010, 08:04 PM

I've been doing golf scoring and statistics for our club for a few years. I've created a spreadsheet that moves the cursor to the next box after a single digit is pressed. You will need to open the Results sheet and click on a cell in the team range and click the button of "Enter Foursome Card". A Userform will open that does what you are asking for. See the attached file.