Return to Cell in Column A after entering value in Column Z

[psctornado]

Hi,

I've been struggling with coming up with VBA code so that anytime a value is entered in column Z that the cursor returns to column A one row below where the entry was in Z.

Example : Cell Z5 Value = 1.5

After entering that value it then returns to cell A6.

Does anyone have any ideas if this is possible & how to do it?

Thanks!

[Paul_Hossler]

Put this in the worksheet code module for the affected sheet




Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
With Target.Cells(1, 1)
If .Column <> 26 Then Exit Sub
Application.Goto .Offset(1, -25), False
End With
End Sub

[psctornado]

Put this in the worksheet code module for the affected sheet




Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
With Target.Cells(1, 1)
If .Column <> 26 Then Exit Sub
Application.Goto .Offset(1, -25), False
End With
End Sub




Excellent. I was using an activecell formula similar but it wasn't working. This is perfect. Thanks for the help!