set macro to a cell

  • Thread starter Thread starter GAME.ON.GFX
  • Start date Start date
G

GAME.ON.GFX

How do I set a macro to go to a specific cell when my cursor hits a specified
cell?When I type down column K2, k3, k4, k5, then hit enter into k6, I want
the cursor to go back to k2.
Thanks.
 
You don't really need a macro for that. If you highlight cells K2:K6 and then
start typing with them highlighted, your cursor will do what you described.
 
Attach the following to the worksheet you are working on...
Assumption: The cursor goes to K7 when you enter something in K6 and press
Enter...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$K$7" Then
Range("K2").Activate
End If
End Sub
 
I think you needed to go back to K2 after K5. In that case change $k$7 to $K$6.

However JBeaucaire's suggestion is much better.
 
Back
Top