read only column , point to opposite field when selected

Folks

the below successfully makes my column a rea-only and when clicking anyway in column a it defaults back to field b3

how do I for example when clicking in field a4 then place me into column b4 or when in a27 then point me to b27



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Selection, Range("A:A")) Is Nothing Then
    Range("B3").Select
    End If
End Sub
rutgermonsAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
target.offset(,1).Select
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.