goto function

Hi there,

Hope someone can help. I've been looking for a while now but can't seem to find what i'm looking for.

Basically I need cell B16 to jump to cell B2 automatically once the cell is active.

I have a sheet like this
B2 1
B3 3
B4 4 and so on.... and when i get to

B16 I don't want to enter anything but as soon as I hit enter on cell B15 and B16 becomes active, I want it to jump back to B2 so i can start the process again and enter new values.

Any ideas?

Many thanks

Try this

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$16" Then Cells(2, 2).Select
End Sub

Copy the Excel VBA code
Select the workbook in which you want to use the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save