Application.MoveAfterReturnDirection - Capturing cursor move direction

[mowens74]

Hello,

I have the following scrip that runs when the workbook is opened....

Please Login or Register  to view this content.

and then the following that runs when the workbook is closed....

Please Login or Register  to view this content.

This workbook I have contains VBScript that rely's on the cursor movement going to the right (or staying on the same line as the cell that has just been modified).
On opening the workbook I am trying to capture the cursor movement in a variable then change the direction to <right>, on closure of the workbook it uses the variable to change it back to what it was.
The changing of direction to <right> is working but when I close the workbook it is changing the direction to <left> which isn't correct (for my tests I have been setting the cursor direction to <down>).

Please can someone help. Thanks.

[Jakobshavn]

Use the BeforeSave Event rather than the BeforeClose Event.

[HaHoBe]

Hi, Marc,

CursorMove is a local variable known for Workbook_Open but unknown to Workbook_BeforeClose. You would need to make it a global variable (Public in a standard module). And AFAIR these values are of Type Long, not of String.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HTH,
Holger

[JosephP]

why does your code rely on the cursor direction?

[mowens74]

Jakobshavn : I thought about the 'BeforeSave' option a user may go into the Workbook and then exit without saving so didn't think this option would work.

JosephP : I'll answer so that I don't appear rude. I have am using the 'Selection.Offset' command to automatically add contents and data validation to the same line depending on what the user enters in certain cells. If the cursor moved away from the line that the edited cell was on it messed things up.

HaHoBe : This worked, thank you.


Thanks to you all for getting back to this thread so quickly :-D

[JosephP]

if you are using a worksheet_change event to add the validation you can use the Target argument, which refers to the changed cell, rather than rely on the currently selected cell