Cursor movement

[Andrew Bourke]

Hi
I run a sheet change macro when a value changes in a cell. What I would
like to control is where the cursor goes after the macro has finished.
For example, if after entering a value in a cell and I then press the
right arrow key, I would like the cursor to go right.
Is this possible ?

TIA

Andrew Bourke

 

[Don Guillett]

Does this help?
..offset(,1).select

 

[Andrew Bourke]

Does this help?
.offset(,1).select

Thanks for your reply, I can see what this does but it is not quite what
I needed.

Data is entered into a cell and sometimes the user presses enter to go
down, or the right arrow key to go across. I need to know which is which
so I can make the next active cell the appropriate one.

TIA

 

[Anant Basant]

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Offset(, 1).Select
End Sub

Probably is what you want to do. When user changes Target and presses enter
or arrow or selects any other cell, this code would run and select the cell
to the right.

 

[Andrew Bourke]

Hi
I have almost found what I need by inserting:

Application.Onkey "{RIGHT}", "RightArrowKeyPressed"

The sub RightArrowKeyPressed stores a value in a temp cell to tell me
the right arrow key has been pressed.
Before I exit the main routine I check for this temp value - empty and
the cursor is moved down, non empty and the cursor moves right.

The only issue I have now is that it doesn't seem to work on the first
instance.