Good day all,

I've been asked a question that I can't answer.... so here it is....

Is there a way to move the active cell to another one as soon as it fills a
criteria without having to hit "ENTER". In other words. In cell A1 a 4
digit number is to be entered. In cell A2 a 2 digit number is to be
entered.

From cell A1, the user would type 6 digits and as soon as the 4th digit is
typed, the activecell would continue to A2. This way the user doesn't need
to hit ENTER or TAB.


Regards,

MD