Trapping Data Input with Curser Keys or Entry Key

[Robert Cornwell]

Hello,

In a worksheet change event macro I make use of
"target.offset(1, -10).select" i.e select new line for data input - works
fine -
I would like to trap the entry of this data when using the enter key and
follow with the new line selection as above i.e so that the curser keys
work normally for data entry thus avoiding the new line selection.
The purpose being - auto select next cell or personal choice!

Is this possible? or alternative work round?

Any guidance would be appreciated.

Robert

 

[Bob Kilmer]

You might be able to make something of this.

Application.OnKey "{RETURN}", "NextRow" 'maybe run this on workbook open

Public Sub NextRow()
ActiveCell.Offset(1, -10).Select
End Sub

Bob