CODEWITHSUNDEEP
excelvba
Joe R.
Joe R.

Reputation: 2052

How can I control moving cursor movement after entering a value in a cell?

I would like to control which cell the cursor should or should not move to after entering a value in a particular cell.

Upvotes: 1

Views: 1521

Answers (1)

Vishnu Pradeep
Vishnu Pradeep

Reputation: 2097

try VBA.

example code

Private Sub Worksheet_Change(ByVal Target As Excel.Range) 
Select Case Target.Address() 
Case "$A$1" 
  Range("$C$15").Select 
Case "$C$15" 
  Range("$F$9").Select 
Case "$F$9" 
  Range("$A$1").Select 
End Select 
End Sub

Upvotes: 1

Related Questions