Automatically jump to cell

Mar 12th, 2002, 03:28 AM

Hi,
I have a sheet where users enter their details. Is there a way, such that, after a user enters data in cell B2, the cell will automatically jump to cell D8?
ie. In cell B2 -> Type '12345' -> Press Enter -> In cell D8

Thanks!

Dave Hawley · Mar 12th, 2002, 03:43 AM

Hi

Right click on the sheet name tab select "View Code" and paste in this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then Range("D8").Select
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 03:28 AM	#1
Guest Posts: n/a	Hi, I have a sheet where users enter their details. Is there a way, such that, after a user enters data in cell B2, the cell will automatically jump to cell D8? ie. In cell B2 -> Type '12345' -> Press Enter -> In cell D8 Thanks!

Mar 12th, 2002, 03:43 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Right click on the sheet name tab select "View Code" and paste in this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$2" Then Range("D8").Select End Sub