|
楼主 |
发表于 2011-1-27 20:04
|
显示全部楼层
Private Sub CommandButton1_Click()
Dim a As String
Dim b As Integer
a = TextBox1.Text
If a = "" Then
MsgBox "查无此人请检查重新输入"
Else
Workbooks("实验.xls").Sheets("biao").Activate
Sheets("biao").Range("a2").Select
Selection.End(xlDown).Select
Selection.End(xlToLeft).Select
b = ActiveCell.Row
For i = 2 To b
If Worksheets("biao").Cells(i, 1).Value = a Then
Worksheets("打印模块").Cells(5, 2) = Worksheets("biao").Cells(i, 1).Value
Worksheets("打印模块").Cells(4, 2) = Worksheets("biao").Cells(i, 3).Value
Worksheets("打印模块").Cells(4, 4) = Worksheets("biao").Cells(i, 4).Value
Worksheets("打印模块").Cells(4, 7) = Worksheets("biao").Cells(i, 5).Value
Worksheets("打印模块").Cells(6, 2) = Worksheets("biao").Cells(i, 2).Value
Worksheets("打印模块").Cells(7, 2) = Worksheets("biao").Cells(i, 9).Value
Worksheets("打印模块").Cells(6, 4) = Worksheets("biao").Cells(i, 8).Value
Worksheets("打印模块").Cells(5, 4) = Worksheets("biao").Cells(i, 6).Value
Exit For
Else:
Dim c
c = c + 1
End If
Next
If c + 1 = b Then
Application.Goto Workbooks("实验.xls").Sheets("打印模块").Range("a1")
MsgBox "查无此人请检查重新输入"
End If
End If
Application.Goto Workbooks("实验.xls").Sheets("打印模块").Range("a1")
End Sub |
|