1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| Dim f, TblBd
Private Sub UserForm_Initialize()
Set f = Sheets("DTEL")
Set D = CreateObject("Scripting.Dictionary")
a = Split(TblBd(i, 39), ";")
D("*") = ""
For i = LBound(TblBd) To UBound(TblBd)
a = Split(TblBd(i, 39), ";")
For Each C In a: D(C) = "": Next C
Next i
Me.ComboBox1.List = D.keys
Me.ComboBox1 = ActiveSheet.[A1]
End Sub
Private Sub ComboBox1_click()
ListBox1.Clear
j = 0
For i = LBound(TblBd) To UBound(TblBd)
If (InStr(TblBd(i, 39), ComboBox1) > 0 And TblBd(i, 5) Like ComboBox2) _
Or (Me.ComboBox1 = "*" And TblBd(i, 5) Like ComboBox2) Then
ListBox1.AddItem
ListBox1.List(j, 0) = TblBd(i, 2)
ListBox1.List(j, 1) = TblBd(i, 9)
ListBox1.List(j, 2) = TblBd(i, 40)
ListBox1.List(j, 3) = TblBd(i, 37)
j = j + 1
End If
Next i
End Sub |
Partager