Bonjour,
Option Compare Text
Dim nomTableau, TBlBD()
Private Sub UserForm_Initialize()
nomTableau = "Tableau1"
TBlBD = Range(nomTableau).Value
Me.ListBox1.List = TBlBD
Me.ListBox1.ColumnCount = UBound(TBlBD, 2)
'--- ComboBox
Set d = CreateObject("scripting.dictionary")
d("*") = ""
For i = 1 To UBound(TBlBD): d(TBlBD(i, 4)) = "": Next i
Me.ComboBox1.List = d.keys
EnteteListBox
End Sub
Private Sub ComboBox1_click()
ColRecherche = 4
clé = Me.ComboBox1: n = 0
Dim Tbl()
For i = 1 To UBound(TBlBD)
If TBlBD(i, ColRecherche) Like clé Then
n = n + 1: ReDim Preserve Tbl(1 To UBound(TBlBD, 2), 1 To n)
For k = 1 To UBound(TBlBD, 2): Tbl(k, n) = TBlBD(i, k): Next k
End If
Next i
If n > 0 Then Me.ListBox1.Column = Tbl Else Me.ListBox1.Clear
End Sub
Boisgontier