Private Sub Worksheet_SelectionChange(ByVal R As Range)
If Not Intersect(R, Range("f6")) Is Nothing Then
Dim ac As Range
Set ac = ActiveCell
Application.ScreenUpdating = False
Sheets("truc").Activate
ActiveCell.Offset(0, 4) = ac.Offset(0, 1).Value
Application.Goto ac 'retour
Application.ScreenUpdating = True
End If
End Sub