Private Sub CommandButton1_Click()
Dim DerLig As Long
With Workbooks("Interventions.xlsm").Sheets("Interventions")
DerLig = .Range("A" & Rows.Count).End(xlUp).Row
.Range("A" & DerLig + 1).Value = ComboBox4.Value
.Range("B" & DerLig + 1).Value = Workbooks("Interventions.xlsm").Sheets("EnCours").Range("B" & ComboBox4.ListIndex + 2).Value
.Range("C" & DerLig + 1).Value = Workbooks("Ventes.xls").Sheets("Ventes 2010").Range("B" & ComboBox4.ListIndex + 2).Value
lig = Application.Match(ComboBox4, Sheets("EnCours").Range("A1:A" & Cells(Application.Rows.Count, 1).End(xlUp).Row))
Sheets("EnCours").Rows(lig).Delete
End With
Call nb_heure
End Sub