View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Auto Jump to Cell

Sorry but that is just not possible. No events are firing while a cell is
being edited so you can not actively monitor the number of characters that
have been entered. What you could do is set it up such that once the entire
string has been input and the user hits enter to commit the change, you could
then split the input into multiple cells if you wish... If you want help with
that just reply back...
--
HTH...

Jim Thomlinson


"Dennis" wrote:

Is there a way to set up a particular cell so that, when a specific number of
characters have been typed by the user, the curser will jump to another cell?
I'd like to use this feature, if it can be done, in a template.