moving between cells

[otis]

Is it possible to move to a cell that may be 5 rows down and 2 columns over for example without actually having to arrow over to that cell after hitting enter in the current input cell?

thanks, Mark

 

[Tazguy37]

Do you want to move the same number of columns and rows each time? Would there only be one input cell?

You could use something like this in that sheet's Worksheet_Change() event:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Application.Intersect(Range("C5"), Target) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    Target(5, 3).Select                 'move to E9 from C5
    Application.EnableEvents = True

End Sub

• How to use the above code:
  
  Press Alt-F11 to open the VBE.
  Press Control-R to open the Project Explorer.
  Click "Microsoft Excel Objects" for the file you're working on.
  Double-click the sheet module where you need this to work.
  
  Open the Code pane with F7.
  Paste the above code in.
  Press Alt-Q to close the VBE and return to Excel

Hope that helps!

 

[otis]

unfortunately, no...the movement would be random, the user just wants to move to the next input cell without doing all the arrowing...

thanks

 

[Artemus]

Try unlocking only those cells that require input. Then protect the sheet being sure to uncheck the "Select locked cells" before clicking OK. That will cause the selection to only move among unlocked cells.