Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I move cells after data input without using enter or tab
I would like to set up a worksheet that allows 1 digit numerical data to be
entered into a cell and then move onto another cell automatically without having to use the "Enter" or "Tab" or "arrow" keys |
#2
|
|||
|
|||
Mull
Cannot be done. How would Excel know that you had finished typing if you didn't indicate in some fashion? Code cannot run when you are in "Edit" mode, which is the mode you are in when entering something in a cell. Gord Dibben Excel MVP On Wed, 2 Mar 2005 06:11:03 -0800, "mull" wrote: I would like to set up a worksheet that allows 1 digit numerical data to be entered into a cell and then move onto another cell automatically without having to use the "Enter" or "Tab" or "arrow" keys |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |