If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
automatically advance to next cell without hitting enter or tab
does anyone know of a way to have Excel move automatically to the next
cell after entering one digit (without hitting enter every time?) If there is some sort of script or something that anyone is aware of that already exists that I would need, can you please point me to it and tell me how to set it up? |
#2
|
|||
|
|||
automatically advance to next cell without hitting enter or tab
Hi
AFAIK this is not possible as you can't run macros while in Edit mode -- Regards Frank Kabel Frankfurt, Germany corby wrote: does anyone know of a way to have Excel move automatically to the next cell after entering one digit (without hitting enter every time?) If there is some sort of script or something that anyone is aware of that already exists that I would need, can you please point me to it and tell me how to set it up? |
#3
|
|||
|
|||
automatically advance to next cell without hitting enter or tab
Excel doesn't know you have entered anything until you touch the enter or an
arrow key or the tab key. -- Don Guillett SalesAid Software "corby" wrote in message ... does anyone know of a way to have Excel move automatically to the next cell after entering one digit (without hitting enter every time?) If there is some sort of script or something that anyone is aware of that already exists that I would need, can you please point me to it and tell me how to set it up? |
#4
|
|||
|
|||
automatically advance to next cell without hitting enter or tab
You could use a small userform that only accepts one character.
Here's an example to get just a single digit: http://groups.google.com/groups?thre...7D33%40msn.com corby wrote: does anyone know of a way to have Excel move automatically to the next cell after entering one digit (without hitting enter every time?) If there is some sort of script or something that anyone is aware of that already exists that I would need, can you please point me to it and tell me how to set it up? -- Dave Peterson |
#5
|
|||
|
|||
automatically advance to next cell without hitting enter or tab
Never say never. Check http://groups.google.com/groups?threadm=
4085DF50.CA7B7D33%40msn.com for one way to do what you want -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... does anyone know of a way to have Excel move automatically to the next cell after entering one digit (without hitting enter every time?) If there is some sort of script or something that anyone is aware of that already exists that I would need, can you please point me to it and tell me how to set it up? |
Thread Tools | |
Display Modes | |
|
|