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.
|