VBA: Change default cursor movement for the workbook [Solved]

[inddon]

Hello There,

By default when you enter a value in a cell and press 'Enter' key the cursor moves to next row same column.

What I am looking for is when you press 'Enter' key the cursor should navigate to next column of the same row.

Could you please advise how this can be achieved using VBA?


Thanks & regards
Don

 

[Smallman]

Hi inddon

Give the following a try. One will make it go the way you want the other will return the cursor back to normal function.

Sub GoRight()
    Application.MoveAfterReturnDirection = xlToRight
End Sub

Sub GoSouth()
    Application.MoveAfterReturnDirection = xlDown
End Sub

Take care

Smallman

 

[inddon]

Hi inddon

Give the following a try. One will make it go the way you want the other will return the cursor back to normal function.

Sub GoRight()
    Application.MoveAfterReturnDirection = xlToRight
End Sub

Sub GoSouth()
    Application.MoveAfterReturnDirection = xlDown
End Sub

Take care

Smallman

Hello Smallman,

Thank you for your quick response and solution.

I place it in worksheet change procedure and it works fine.

May I ask you to kindly update the post as [SOLVED]


Regards
Don

 

[Smallman]

Hi inddon

Here is a file which should help you a little more. Sorry for not attaching one in the first place.

Take care

Smallman

 

[inddon]

Hi inddon

Here is a file which should help you a little more. Sorry for not attaching one in the first place.

Take care

Smallman

Hello Smallman,

It works fine.

May I ask you to kindly update the post as [SOLVED]


Many thanks & regards
Don

 

[Smallman]

Hi @inddon

I don't think we do mark posts as solved. But it is really nice when people like yourself take the time to say suggestions helped. Other people looking in future will know that they should be able to adapt the solution.

All the best

Smallman

 

[inddon]

Hi @inddon

I don't think we do mark posts as solved. But it is really nice when people like yourself take the time to say suggestions helped. Other people looking in future will know that they should be able to adapt the solution.

All the best

Smallman

Hello Smallman,

Most of my previous post when solved, I use to ask the Ninja's to mark it as solved. They use to update (prefix or postfix) the post's Subject with the word [SOLVED]. Since you are a Ninja yourself and you have solved it , therefore asking you to please do the needful.

Regards
Don

 

[ashish mehra]

Hi Inddon,

Here is a non-vba solution in excel.

1) Go to File ribbon
2) Select Options
3) Click on Advanced menu
4) In Editing options there is Direction drop down, select Right

The cursor will move in the specified direction from now-onward.

Regards,
AM

 

[inddon]

Hi Inddon,

Here is a non-vba solution in excel.

1) Go to File ribbon
2) Select Options
3) Click on Advanced menu
4) In Editing options there is Direction drop down, select Right

The cursor will move in the specified direction from now-onward.

Regards,
AM

Thanks Ashish, learned something new from you today.

Regards
Don

 

[ashish mehra]

Its my pleasure Don

Regards,
AM