View Single Post
  #6   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 about that I ended up in a meeting that just would not end. If you
still need help drop me an e-mail and I will send you something (I might end
up in another meeting a little later)...
--
HTH...

Jim Thomlinson


"Dennis" wrote:

Yes, that might be something I can use. I would be interested in learning
how that could be done. Thanks.

"Jim Thomlinson" wrote:

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.