Private Sub CommandButton1_Click()
For i = [a65536].End(xlUp).Row To 3 Step -1
If ComboBox4.Text = Cells(i, 1) and ComboBox5.Text = Cells(i, 2)Then '可以根据这个自己加条件
Rows(i).Delete
End If
Next
End Sub
Private Sub CommandButton1_Click()
For i = [a65536].End(xlUp).Row To 3 Step -1
If ComboBox4.Text = Cells(i, 1) and ComboBox5.Text = Cells(i, 2)Then '可以根据这个自己加条件
Rows(i).Delete
End If
Next
End Sub