Private Sub Cmd_Enregistrer_Click()
Application.ScreenUpdating = False
With [Prod].ListObject
.Range.AutoFilter Field:=.ListColumns("famille produit").Index, Criteria1:=ComboBox1
.Range.AutoFilter Field:=.ListColumns("code article").Index, Criteria1:=ComboBox2
.Range.AutoFilter Field:=.ListColumns("designation").Index, Criteria1:=ComboBox3
End With
'+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
'| [Prod[[Form 1]:[Form 3]]].SpecialCells(xlCellTypeVisible) = "" |
'+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
For I = 0 To Me.Lbx_Form.ListCount - 1
[Prod].ListObject.ListColumns(Lbx_Form.List(I)).DataBodyRange.SpecialCells(xlCellTypeVisible) = _
IIf(Me.Lbx_Form.Selected(I), "X", vbNullString)
Next I
[Prod[ADT]].SpecialCells(xlCellTypeVisible) = IIf(CheckBox1, "X", vbNullString)
[Prod].ListObject.Range.AutoFilter
[Prod].ListObject.Range.AutoFilter
Application.ScreenUpdating = True
End Sub