When a cell is selected, move to a different cell

J

JM

I have a large excel 2007 spreadsheet for data entry. My users are highly
accustomed to using Enter rather than Tab to move right across each row from
columns A to V to enter data, so Enter is set to move the active cell Right.
When users get to column V they may or may not enter data, but they need to
return to column A of the next row.

To facilitate data entry, I put the text "go back" in all cells of column W,
and used the code below to move the active cell back to column A of the next
row when a user hits Enter and moves from column V to column W. Users really
like this function. The PROBLEM: If anyone selects more than one cell of a
row or column on any place in the worksheet, run-time error 13 occurs. Any
solutions?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value = "go back" Then
Cells(Target.Row + 1, 1).Select
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Press Enter and Move Back to Column A Automatically 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Keyboard shortcut to select a column? 7
Copy Link to different cell 2

Top