Go to SELECTED CELLS

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Is there a macro command that would enable a user to jump
to a selected cell?

I have a form with 18 cells to fill up. Lets say A1, B2,
C3, F4, etc.

If the user fills in A1 and press enter or, if the active
cell is A1 and the user uses the tab, it will go to B2 and
so on.

Is this possible?
 
Try this macro

Private Sub Worksheet_Change(ByVal Target As Range
If Target.Address = "$A$1" Then Range("B6").Selec
If Target.Address = "$B$6" Then Range("C1").Selec
If Target.Address = "$C$1" Then Range("A1").Selec
End Sub
 
Thanks! It works when you fill up the cell and press
enter. However, if you press tab, it goes to a "non"
selected cell (between selected cells).
 
I figured it out. The "non" selected cells were
unprotected. Now it's working perfectly.
 
Back
Top