تفضل
Private Sub CommandButton6_Click()
Select Case ComboBox1.Value
Case "بحث في الاسماء"
ListBox1.Clear
For i = 1 To 12
Controls("textbox" & i + 1).Value = ""
On Error Resume Next
Next i
If TextBox1 = "" Then Exit Sub
Sheets("Sheet1").Activate
ss = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
j = 0
For Each C In Range("a2:a" & ss)
If C Like TextBox1.Value & "*" Then
ListBox1.AddItem
ListBox1.List(j, 0) = Cells(C.Row, 1).Value
ListBox1.List(j, 1) = Cells(C.Row, 2).Value
ListBox1.List(j, 2) = Cells(C.Row, 3).Value
j = j + 1
End If
Next C
Case "بحث في الرقم القومي"
ListBox1.Clear
For i = 1 To 12
Controls("textbox" & i + 1).Value = ""
On Error Resume Next
Next i
If TextBox1 = "" Then Exit Sub
Sheets("Sheet1").Activate
ss = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
j = 0
For Each C In Range("c2:c" & ss)
If C Like TextBox1.Value & "*" Then
ListBox1.AddItem
ListBox1.List(j, 0) = Cells(C.Row, 1).Value
ListBox1.List(j, 1) = Cells(C.Row, 3).Value
j = j + 1
End If
Next C
Case "بحث في تاريخ الميلاد"
ListBox1.Clear
For i = 1 To 12
Controls("textbox" & i + 1).Value = ""
On Error Resume Next
Next i
If TextBox1 = "" Then Exit Sub
Sheets("Sheet1").Activate
ss = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
j = 0
For Each C In Range("b2:b" & ss)
If C Like TextBox1.Value & "*" Then
ListBox1.AddItem
ListBox1.List(j, 0) = Cells(C.Row, 1).Value
ListBox1.List(j, 1) = Cells(C.Row, 2).Value
j = j + 1
End If
Next C
End Select
End Sub
1-
2-
3-
project.xlsm