auto select column B

[Av8tordude]

Can someone assist in a vba code that will automatically select column B of the same row the cursor select box.

example.. If I select G15, automatically select B15.

Thank you for your help

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Cells(Target.Row, 2).Select
Application.EnableEvents = True
End Sub

 

[Av8tordude]

Works perfect, Thank you.