move cursor to first cell

[Prasad K]

i am doing data entry from column A to column E here i want to move cursor every next cell to column A automatically based on if i press enter on column E


here i applied this code it's not working

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "E" Then Range("A").Select
End Sub

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.CountLarge > 1 Then Exit Sub
  If Target.Column = 5 Then Range("A" & Target.Row + 1).Select
End Sub

 

[Prasad K]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.CountLarge > 1 Then Exit Sub
  If Target.Column = 5 Then Range("A" & Target.Row + 1).Select
End Sub

Thank you so much @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.