AUTO TAB BETWEEN CELLS

[Tom T]

I have a spreadsheet that I have three cells that I have limited the
number of characters/numbers that can be put in each cellt hrough
vailadation. Is there a way that when a person inputs the required
characters/numbers that the tab will go to the next cell? I have looked at
another question similiar to mine but that code does not work.

 

[IanC]

If you unlock those three cells (Format > Cells > Protection tab, untick
Locked) then protect the worksheet (Tools > Protection > Protect Sheet),
then the tab button will cycle through those 3 cells.

A possible drawback with this is that the user will ONLY be able to enter
data in those 3 cells. On the other hand this could be an advantage

 

[Gord Dibben]

If you want Excel to move to next cell when a number a characters have been
typed, it won't happen.

Validation kicks in after you have hit the ENTER, Tab or arrow key to move
out of the cell.

Excel doesn't know when you have finished editing a cell until you tell it.


Gord Dibben MS Excel MVP

 

[Tom T]

ok. If validatio is not the way to do it. Is there code that will restrict
number of charcters/numbers and auto tab once input te correct
charcters/numbers ?

 

[Gord Dibben]

VBA code will not run while you are in Edit Mode.

You can have event code that counts the number of characters in a cell after
you have hit Enter key.

If number of characters is greater than your desired set point, the contents
will be truncated.

Do you want that?

Maybe you could post the code that "doesn't work".


Gord