View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sumit
 
Posts: n/a
Default regarding form preparation


i am designing a form in excel. i want only maximum one character/letter
to be entered in a particular cell and once it is entered, cursor/active
cell shifts to adjacent cell.

i tried data validation, it helps in restricting maximum text length to
one but i am not able to shift cursor/active cell to adjacent cell.


--
Sumit
------------------------------------------------------------------------
Sumit's Profile: http://www.excelforum.com/member.php...o&userid=29520
View this thread: http://www.excelforum.com/showthread...hreadid=492207