Bonjour le fil, Seb77
Code qui fonctionne
Private Sub CommandButton2_Click()
Dim CelF As Range, Ind As Long, ValSearch As String
For Ind = 0 To ListBox2.ListCount - 1
If ListBox2.Selected(Ind) = True Then ValSearch = Me.ListBox2.List(Ind): Exit For
Next
' Recherche la ligne de la valeur sélectionnées
Set CelF = Range("A:A").Find(What:=ValSearch, LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False)
If Not CelF Is Nothing Then
Cells(CelF.Row, Columns.Count).End(xlToLeft).ClearContents
ListBox2.RemoveItem (Ind)
End If
End Sub
@+