Hi All:
I seek the knowledge of the experts once again...
Can you tell me if it is possible to have the active cell change after a certain number of characters are entered?
I have a spreadhseet that people enter a 36 digit code into. The different fields have a different amount of characters in them. The string is as follows:
J17 can enter 3 characters
K17 can enter 6 characters
L17 can enter 4 characters
M17 can enter 6 characters
N17 can enter 6 characters
O17 can enter 4 characters
P17 can enter 4 characters
Q17 can enter 4 characters
SO what I would like to happen is the user enters the 3 digits in J17 and then the active cell becomes K17 where they enter 6 digits and then the active cell becomes L17... Does this make sense? Currently the user has to Tab to the next cell but if they could enter the number contu=inous that would be great.
Any ideas?
THANKS,
Mark
I seek the knowledge of the experts once again...
Can you tell me if it is possible to have the active cell change after a certain number of characters are entered?
I have a spreadhseet that people enter a 36 digit code into. The different fields have a different amount of characters in them. The string is as follows:
J17 can enter 3 characters
K17 can enter 6 characters
L17 can enter 4 characters
M17 can enter 6 characters
N17 can enter 6 characters
O17 can enter 4 characters
P17 can enter 4 characters
Q17 can enter 4 characters
SO what I would like to happen is the user enters the 3 digits in J17 and then the active cell becomes K17 where they enter 6 digits and then the active cell becomes L17... Does this make sense? Currently the user has to Tab to the next cell but if they could enter the number contu=inous that would be great.
Any ideas?
THANKS,
Mark