Forum Discussion
Enter Number in cell and automaticaly tab to next cell
I want to enter a number in one cell and then automatically tab to next cell and continue for at least nine cells.
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.
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.