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.

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.

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.

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" <(E-Mail Removed)> wrote in message
news:BCCF787C-29E8-42AC-AF00-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:ec4mg2$2jo6$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:BCCF787C-29E8-42AC-AF00-(E-Mail Removed)...
>> 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.
>
>

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.