how do i enfoce a"auto-tab or jump" to next cell

M

Mike in Bangkok

I have limited data entry in validation to one character. Now i want that the
moment the one character is entered the cusrser to jump to the next cell.
How ?
Also - how to i limit data entry to letters only ? I can see only text in
validation - but that allows numbers as well.
 
J

Jan Karel Pieterse

Hi Mike,
Also - how to i limit data entry to letters only ?
Click to expand...

If the cell is cell A1, use this custom formula for the validation:

=MAX(1*(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1)))))=0

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
M

Mike in Bangkok

Hi Jan, thanks - it avoids the numbers now. But it does not limit the number
of charaters to one !!! :((
 
J

Jan Karel Pieterse

Hi Mike,
But it does not limit the number
of charaters to one !!! :((
Click to expand...

O yes, silly me. Like this:

If the cell is cell A1, use this custom formula for the validation:

=AND(NOT(ISNUMBER(VALUE(A1))),LEN(A1)<=1)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
B

benlee

Mike,
It sounds like you know how to limit the number of characters that can be
entered into a cell.
Could you tell me how to do that please??

Thanks
 
Top