Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Forcing the cursor to move to A of the next line after D of the pr

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor
will automatically go to column A of the next line. My sheet is only using
columns A thru D, which is the way I want it, but when I hit return or enter,
I would like the cursor to go to the next line below to start data entry in
column A again.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default Forcing the cursor to move to A of the next line after D of the pr

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the
cursor
will automatically go to column A of the next line. My sheet is only
using
columns A thru D, which is the way I want it, but when I hit return or
enter,
I would like the cursor to go to the next line below to start data entry
in
column A again.


Adding this procedure...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 Then Cells(Target.Row + 1, 1).Activate
End Sub

to the worksheet's code window in a VBA macro appears to do what you asked.

Rick

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default Forcing the cursor to move to A of the next line after D of the pr

Not the best, but one way...
Select (click on Column Header) Columns E - IV
Format, Columns, Hide.
Only A:D are now visible..
Click in A1;
Press TAB Key, once, twice and a third time.
Then Press the Enter-Key (While in Column D)

This only work if you start Tabbing from Column A only.




"Kitti" wrote:

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor
will automatically go to column A of the next line. My sheet is only using
columns A thru D, which is the way I want it, but when I hit return or enter,
I would like the cursor to go to the next line below to start data entry in
column A again.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Forcing the cursor to move to A of the next line after D of the pr

Couple of ways to do this.

1. Unlock columns A:D then protect the sheet. The Tab key will then do as you
wish or the Enter key will work if set to move right after entry.

2. With no protection, start in column A and Tab your way across to D then hit
Enter key to go back to A one row down.


Gord Dibben MS Excel MVP

On Sat, 16 Jun 2007 07:51:00 -0700, Kitti
wrote:

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor
will automatically go to column A of the next line. My sheet is only using
columns A thru D, which is the way I want it, but when I hit return or enter,
I would like the cursor to go to the next line below to start data entry in
column A again.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default Forcing the cursor to move to A of the next line after D of the pr

Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the
cursor
will automatically go to column A of the next line. My sheet is only
using
columns A thru D, which is the way I want it, but when I hit return or
enter,
I would like the cursor to go to the next line below to start data entry
in
column A again.


Adding this procedure...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 Then Cells(Target.Row + 1, 1).Activate
End Sub

to the worksheet's code window in a VBA macro appears to do what you
asked.


By the way, for your request to make sense, I assumed you have your "Move
Selection After Enter" option set to "Right".

Rick

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get tab to move the cursor one cell over rather than 8? Mysti4God Excel Worksheet Functions 2 August 11th 06 07:04 PM
Several questions about move cursor Hank Excel Discussion (Misc queries) 1 August 4th 06 10:44 PM
Move cursor to next row Hank Excel Discussion (Misc queries) 1 August 4th 06 09:56 PM
Move Cursor to A1 Silver Excel Discussion (Misc queries) 3 January 7th 05 03:49 PM
Forcing text onto new line in cell Doug Poll New Users to Excel 2 December 3rd 04 01:09 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"