Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lig&, ligne&, rechval
If Not Intersect(Target, Range("b1:b10000")) Is Nothing Then Exit Sub
ligne = Range("b65536").End(xlUp).Row + 1
With Sheets("Table").Columns(2)
Set rechval = .Cells.Find(Range("a" & ligne).Value)
End With
lig = rechval.Row
Range("b" & ligne) = Sheets("Table").Cells(lig, 3)
End Sub