Private Sub CommandButton10_Click()
Sheets("AS10_ET").Range("B1").Value = TextBox1.Value
Call Copie_filtre
End Sub
*******************************
Private Sub Copie_filtre()
Dim NbLg As Long
Dim LgDer As Long
Dim Critere As String
Sheets("AS10_ET").Select
Critere = "B000*"
With Sheets("AS10_ET")
LgDer = .Range("E65536").End(xlUp).Row
.Range("E1:E" & LgDer).AutoFilter Field:=5, Criteria1:=Critere
NbLg = WorksheetFunction.Subtotal(3, Columns(1)) - 1
If NbLg > 0 Then
.Range("E4:E" & LgDer).SpecialCells(xlCellTypeVisible).Copy Sheets("AS10_ET").Range("H1")
End If
.ShowAllData
End With
Range("B1").Activate
Sheets("Planning").Select
End Sub