Cursor movement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i move the cursor from the end of a row to the beginning of the next
row after pressing ENTER
 
Hi, write a VBA code that does the following,
1. Check if the current cell is the last cell in the current row
2. If so, then set focus on the first cell of next row and activate it
I hope the above should help you.
 
Start in A1 and Tab your way across the row as you enter your data.

When you get to the last data cell in that row, hit ENTER key to go back to
column A, next row down.

With this method, you will always go back to starting column one row down.

i.e. if you start in column C and Tab across, hitting ENTER key will move you
back to column C.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Oversensitive touchpad on modern laptops 0
"NxtRow = Cells(Rows.Count," giving me fits 3
moving to next cell without keyboard 2
Setting the Transition Function for two columns 4
cursor behavious when restricting selection to unlocked cells 4
set cursor position after cell is populated?? 7
Datagridview Cursor movement 1

Back
Top