|
发表于 2011-11-30 11:38
|
显示全部楼层
本楼为最佳答案
完善几 小细节:
- Private Sub CommandButton1_Click()
- If j > 1 Then
- j = j - 1
- TextBox2.Text = Arrk(1, j)
- TextBox3.Text = Arrk(2, j)
- End If
- End Sub
- Private Sub CommandButton2_Click()
- If j < k Then
- j = j + 1
- TextBox2.Text = Arrk(1, j)
- TextBox3.Text = Arrk(2, j)
- End If
- End Sub
- Private Sub CommandButton3_Click()
- Dim i As Integer, arr
- Erase Arrk: k = 0: j = 0
- If TextBox1 = "" Then
- MsgBox "姓名为必输项!"
- TextBox1.SetFocus
- Exit Sub
- End If
- With Sheets("模拟数据")
- arr = .Range("A2:E" & .[a65536].End(3).Row)
- For i = 1 To UBound(arr)
- If arr(i, 2) Like "*" & TextBox1.Value & "*" Then
- k = k + 1: ReDim Preserve Arrk(1 To 2, 1 To k)
- Arrk(1, k) = arr(i, 4)
- Arrk(2, k) = arr(i, 5)
- End If
- Next
- If k > 0 Then TextBox2.Text = Arrk(1, 1): TextBox3.Text = Arrk(2, 1): j = 1
- End With
- End Sub
- Private Sub CommandButton4_Click()
- TextBox1 = ""
- TextBox2 = ""
- TextBox3 = ""
- End Sub
- Private Sub UserForm_Initialize()
- TextBox1 = ""
- TextBox2 = ""
- TextBox3 = ""
- TextBox1.SetFocus
- End Sub
复制代码
见附件效果:
示例.rar
(22 KB, 下载次数: 21)
|
|