Moving cursor from certain cell to another certain cell by pressing enter

[hitka]

I want cursor to move from cell “L43” to cell “S28” after inputting data and pressing enter.

 

[mohadin]

Hi
Welcome to the forum
Put this code in the sheet code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("L43")) Is Nothing Then
        Range("S28").Select
    End If
End Sub

 

[My Aswer Is This]

The cursor does not move but the cell is selected:
Try this
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  12/21/2021  5:22:00 AM  EST
If Target.Address = "$L$43" Then Range("S28").Select
End Sub