و عليكم السلام و رحمة الله
ضع الكود التالى فى حدث الفورم
Private Sub CommandButton1_Click()
Dim Arr, Cond1, Cond2, Cond3
Dim Tmp, p
Arr = Range("A2:B9")
Cond1 = Me.TextBox1.Value
Cond2 = Me.TextBox2.Value
Cond3 = Me.TextBox3.Value
If Cond1 = "" Or Cond2 = "" Or Cond3 = "" Then
MsgBox "asdfghjkl"
Exit Sub
End If
ReDim Tmp(1 To UBound(Arr, 1), 1 To UBound(Arr, 2))
For i = 1 To UBound(Arr, 1)
If Arr(i, 2) = Cond1 Or Arr(i, 2) = Cond2 Or Arr(i, 2) = Cond3 Then
p = p + 1
For j = 1 To 2
Tmp(p, j) = Arr(i, j)
Next
End If
Next
With Me.ListBox1
.Clear
.AddItem
.List = Tmp
End With
End Sub