|
- Private Sub CommandButton1_Click()
- Sheets(1).Range(Sheets(1).Cells(3, 1), Sheets(1).Cells(Rows.Count, 15)).ClearContents
- If TextBox2.Text <> "" Then
- Application.ScreenUpdating = False
- For j = 1 To 12
- If Sheets(1).Cells(2, j) = ComboBox1.Text Then
- a = j
- GoTo l1
- End If
- Next j
- l1:
- a1 = 2
- For j = 2 To 2
- For i = 3 To Sheets(j).Cells(Rows.Count, 3).End(3).Row
- If InStr(Sheets(j).Cells(i, a), TextBox2.Text) > 0 Then
- a1 = a1 + 1
- For k = 1 To 12
- Sheets(1).Cells(a1, k) = Sheets(j).Cells(i, k)
- Next k
- End If
- Next i
- Next j
- Application.ScreenUpdating = True
- Else
- MsgBox "请输入查找关键字"
- End If
- End Sub
复制代码 |
|