| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I disable the cursor movement after hitting enter in a cell | Excel Discussion (Misc queries) | |||
| Automatically move to adjacent cells without hitting Enter | Excel Discussion (Misc queries) | |||
| Cell changes to a formula after hitting ENTER | Excel Discussion (Misc queries) | |||
| how to insert row automatically after hitting enter at the end of. | Excel Worksheet Functions | |||
| moving the cell pointer after hitting enter | Excel Programming | |||
Hybrid Mode
