Move Cursor from one column to another

**wish2excel** · 10-07-2010, 10:36 AM

I was trying with some options here to move the cursor from Column A to Column B after some text is entered into it.can some body help me with that?

**Marcol** · 10-07-2010, 11:09 AM

Have you tried using the arrow keys?

**Leith Ross** · 10-07-2010, 11:21 AM

Hello wish2excel,

If you want to change the direction of the direction of the cursor after Enter is pressed, you can change the Direction setting for Excel. This will effect all worksheets.

To Change the Direction of the Cursor After Enter is Pressed

On the Menu bar select Tools > Options...
This displays the Options dialog. Select the Edit tab.
Find the box Move selection after Enter. If it is not checked, click it.
Below this box is the Direction drop down. Select Right.

If you want the cursor to move from column A to B and back again on only one sheet or more sheets, you will need a VBA macro. Here is an example.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro

Copy the macro using CTRL+C keys.
Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
Left Click on View Code in the pop up menu.
Paste the macro code using CTRL+V
Make any custom changes to the macro if needed at this time.
Save the macro in your Workbook using CTRL+S

**wish2excel** · 10-07-2010, 11:22 AM

I want to use enter key and move the cursor only if there is some data entered in it,TEXT only not numbers

**Leith Ross** · 10-07-2010, 11:50 AM

Hello wish2excel,

I have a made a change to the macro to check that the cell is not empty.

Please Login or Register  to view this content.

**Marcol** · 10-07-2010, 11:51 AM

Try this in the sheet mudule of the sheet you want to control.

Please Login or Register  to view this content.

Hope this helps

**wish2excel** · 10-27-2010, 05:38 AM

I have made some changes and added more headings to the file,These are the heading that i have now

Column A-Sl No.
Column B -Date
Column C- Time
Column D-Inspection Number
Column E-Credit Hire
Column F-Case Types
Column G-Inspection Date Raised
Column H-Allocation Date
Column I-Booking Date
Column J Allocation Date
Columns K-Booking TAT
Column L-Inspection Reopned
Cloumn M-Reopned Date
Column N-Type of Inspection
Column O-Reason for AUC
Column P-Reason for Delay In Allocation
Column Q-Reason for Delay in Booking
Column R-Comments

The cursor movements are as listed below

Once Sl No. is entered in Cloumn A and press enter cursor should move to column B
( Entered Manually).On column B put current date and move curso to Column C(Automatically)On column C put the current time and move cursor to column D(Automatically).Once the date is entered on Inspection date raised and Allocation date, Allocation TAT is calculated using NetworkDays formula on Column J(Calculated Using Formula).Based on the Allocation TAT value if it is more than 2 cursor should move to Inspection Reopened on Column L.(Automatically)If Inspection Reopened on Column L is YES,Cursor should go to Column M,Reopened Date(Automatically), If Column L is NO, Cursor should go to column P,Reason for delay in Allocation(Automatically).
If J is less than or equal to 2,Cursor should move to Booking Date on column I,(Automatically).After booking date in Column I is entered, Booking TAT is calculated using NetworkDays(Calculated Using Formula). If Booking TAT is more than 2 Cursor should go to Column Q, Reason for Delaying,(Automatically).If Booking TAT is less than 2 Cursor should go to Column N,Type of Inspection(Automatically).If column N Type of Inspection is AUC,Cursor should go to O, Reason for AUC,(Automatically).If column N Type of Inspection is anything else Move cursor to Column R Comments,(Automatically).