Hi @all
Use Intersect() to verify if the changed cell in deed is the one which shall trigger a certain Selection. The rest is easy:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("K12")) Is Nothing Then
Range("G11").Select
End If
End Sub
Changing the value in K12 and pressing "Enter" will select G11.
Cheers