Enter Number in cell and automaticaly tab to next cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1296400%22%20slang%3D%22en-US%22%3EEnter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296400%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20enter%20a%20number%20in%20one%20cell%20and%20then%20automatically%20tab%20to%20next%20cell%20and%20continue%20for%20at%20least%20nine%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1296400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296457%22%20slang%3D%22en-US%22%3ERe%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615024%22%20target%3D%22_blank%22%3E%40jacksiegel76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20Excel%20Preferences%20and%20open%20the%20window%20for%20setting%20Edit%20preferences.%20The%207th%20main%20item%20on%20the%20list%20allows%20you%20to%20tell%20Excel%20where%20to%20move%20your%20selection%20to%2C%20down%2C%20right....whatever%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1586457334047.png%22%20style%3D%22width%3A%20535px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183462i3291585E9D730EDC%2Fimage-dimensions%2F535x475%3Fv%3D1.0%22%20width%3D%22535%22%20height%3D%22475%22%20title%3D%22mathetes_0-1586457334047.png%22%20alt%3D%22mathetes_0-1586457334047.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296493%22%20slang%3D%22en-US%22%3ERE%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296493%22%20slang%3D%22en-US%22%3EIt%20can%20be%20done%20but%20what%20exactly%20you%20want.%20like%20if%20yoiu%20want%20that%20if%20yoiu%20type%20one%20digit%20it%20should%20move%20to%20next%20cell%20or%20two%20digits%20then%20to%20next%20cell.%20You%20have%20to%20be%20very%20specific.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296513%22%20slang%3D%22en-US%22%3ERE%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296513%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20enter%20one%20digit%20in%20a%20cell%20and%20then%20having%20Excel%20tab%20over%20to%20next%20cell.%20I%20am%20trying%20to%20avoid%20using%20the%20tab%20key%20after%20each%20entry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597404%22%20target%3D%22_blank%22%3E%40gyankosh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296534%22%20slang%3D%22en-US%22%3ERE%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296534%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20need%20the%20event%20of%20key%20release%20for%20that.%20I%20have%20no%20idea%20if%20that%20is%20present%20in%20VBA%20or%20not.%20I%20think%20if%20its%20possible%2C%20it'll%20through%20VBA%20only.%3C%2FP%3E%3CP%3EBut%20the%20question%20is%20%2C%20how%20would%20VBA%20change%20the%20system%20settings%20that%20at%20each%20release%20of%20the%20key%2C%20the%20focus%20should%20move%20to%20next%20cell.%3C%2FP%3E%3CP%3ENeed%20some%20time%20to%20think%20about%20it.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615024%22%20target%3D%22_blank%22%3E%40jacksiegel76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296579%22%20slang%3D%22en-US%22%3ERE%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296579%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615024%22%20target%3D%22_blank%22%3E%40jacksiegel76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EI%20am%20trying%20to%20enter%20one%20digit%20in%20a%20cell%20and%20then%20having%20Excel%20tab%20over%20to%20next%20cell.%20I%20am%20trying%20to%20avoid%20using%20the%20tab%20key%20after%20each%20entry.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22enter%22%20means%20what%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20mean%20touch%20the%20%22Enter%22%20or%20%22Return%22%20key%2C%20then%20that%20preference%20setting%20I%20gave%20you%20will%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20literally%20mean%20only%20that%20you%20want%20to%20type%20a%20single%20digit%20and%20have%20it%20entered%20and%20the%20active%20selection%20moved%2C%20then%20as%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597404%22%20target%3D%22_blank%22%3E%40gyankosh%3C%2FA%3E%20has%20said%2C%20maybe%20you%20could%20come%20up%20with%20a%20VBA%20routine%20or%20some%20such.%20But%20of%20course%2C%20that%20has%20to%20be%20activated%20too%2C%20and%20yes%2C%20something%20could%20no%20doubt%20be%20written%20that%20would%20keep%20looping%20until%20you%20hit%20%22Esc%22%20or%20some%20such....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20many%20thousand%20digits%20are%20you%20planning%20on%20entering%20in%20this%20way%3F%20Will%20you%20not%20want%20sometimes%20to%20go%20right%2C%20others%20down%3F%20Is%20there%20quality%20control%20along%20the%20way%3F%20If%20the%20digits%20are%20random%2C%20you%20could%20use%20the%20random%20number%20function....%20if%20they're%20not%2C%20then%20a%20little%20more%20time%20might%20reward%20the%20slowness.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2656438%22%20slang%3D%22en-US%22%3ERE%3A%20Enter%20Number%20in%20cell%20and%20automaticaly%20tab%20to%20next%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2656438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20submitting%20a%20use%20case%20as%20possible%20reason%20for%20the%20initial%20post%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnter%20golf%20scores%20that%20are%20limited%20to%20a%20single%20digit%2C%20since%20we%20play%20with%20max%20of%20par%20%2B%202%2C%20entries%20are%20always%201%20-%207%20for%209%20or%2018%20cells%20in%20one%20row%20(player).%3C%2FP%3E%3CP%3EAnd%2C%20yes%20after%209%20or%2018%20score%20entries%20I%20would%20like%20to%20drop%20to%20next%20row%2Fplayer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20last%20player%2C%20yes%2C%20then%20possibly%20need%20a%20special%20key%20or%20some%20action%20to%20indicate%20all%20player%20scores%20have%20been%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to enter a number in one cell and then automatically tab to next cell and continue for at least nine cells.

6 Replies

@jacksiegel76 

 

Go to Excel Preferences and open the window for setting Edit preferences. The 7th main item on the list allows you to tell Excel where to move your selection to, down, right....whatever

mathetes_0-1586457334047.png

 

It can be done but what exactly you want. like if yoiu want that if yoiu type one digit it should move to next cell or two digits then to next cell. You have to be very specific.

I am trying to enter one digit in a cell and then having Excel tab over to next cell. I am trying to avoid using the tab key after each entry.

 

@gyankosh 

We need the event of key release for that. I have no idea if that is present in VBA or not. I think if its possible, it'll through VBA only.

But the question is , how would VBA change the system settings that at each release of the key, the focus should move to next cell.

Need some time to think about it.

@jacksiegel76 

@jacksiegel76 

 

I am trying to enter one digit in a cell and then having Excel tab over to next cell. I am trying to avoid using the tab key after each entry.

 

"enter" means what?

 

If you mean touch the "Enter" or "Return" key, then that preference setting I gave you will work.

 

If you literally mean only that you want to type a single digit and have it entered and the active selection moved, then as @gyankosh has said, maybe you could come up with a VBA routine or some such. But of course, that has to be activated too, and yes, something could no doubt be written that would keep looping until you hit "Esc" or some such....

 

How many thousand digits are you planning on entering in this way? Will you not want sometimes to go right, others down? Is there quality control along the way? If the digits are random, you could use the random number function.... if they're not, then a little more time might reward the slowness.

@mathetes

 

Just submitting a use case as possible reason for the initial post:

 

Enter golf scores that are limited to a single digit, since we play with max of par + 2, entries are always 1 - 7 for 9 or 18 cells in one row (player).

And, yes after 9 or 18 score entries I would like to drop to next row/player.

 

On last player, yes, then possibly need a special key or some action to indicate all player scores have been entered.