Auto Jump to Cell
 

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.

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.

Auto Jump to Cell
 

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.

Auto Jump to Cell
 

Hi Dennis

Try this, please.

Right click on your sheet tab and place below.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B2" Then
If UCase(Left(Target.Value, 2)) = "JB" Then
Application.EnableEvents = False
Me.Range("c1").Select
Application.EnableEvents = True
End If
End If
End Sub

--
Best regards
Joergen Bondesen


"Dennis" wrote in message
...
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.

Auto Jump to Cell
 

Hi Dennis.

Sorry aboute my first answer.

Modify below for your purpose.


Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B2" Then
If Abs(Len(Range("b2")) - Range("A1").ID) = 3 Then
Application.EnableEvents = False
Me.Range("c1").Select
Application.EnableEvents = True
End If
End If
End Sub


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(False, False) = "B2" Then
Range("A1").ID = Len(Range("b2"))
End If
End Sub


--
Best regards
Joergen Bondesen


"Joergen Bondesen" wrote in message
...
Hi Dennis

Try this, please.

Right click on your sheet tab and place below.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B2" Then
If UCase(Left(Target.Value, 2)) = "JB" Then
Application.EnableEvents = False
Me.Range("c1").Select
Application.EnableEvents = True
End If
End If
End Sub

--
Best regards
Joergen Bondesen


"Dennis" wrote in message
...
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.

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.