|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub CommandButton1_Click()
With Me.ListBox2
If Me.TextBox1 = "" Then Exit Sub
te = Me.TextBox1.Text
Dim n%
n = 1
Me.Height = 320
Dim arrnew
ReDim arrnew(1 To 7, 1 To 1)
arrnew(1, 1) = "NO"
arrnew(2, 1) = "姓名"
arrnew(3, 1) = "身份证号码"
arrnew(4, 1) = "手机号"
arrnew(5, 1) = "有效工时"
arrnew(6, 1) = "餐费"
arrnew(7, 1) = "工资"
For i = 2 To UBound(arr)
If arr(i, 1) Like te Then
n = n + 1
ReDim Preserve arrnew(1 To 7, 1 To n)
arrnew(1, n) = arr(i, 1)
arrnew(2, n) = arr(i, 2)
arrnew(3, n) = arr(i, 3)
arrnew(4, n) = arr(i, 4)
arrnew(5, n) = arr(i, 5)
arrnew(6, n) = arr(i, 6)
arrnew(7, n) = arr(i, 7)
End If
Next i
arrnew = WorksheetFunction.Transpose(arrnew)
With Me.ListBox2
.ColumnCount = 7
.ColumnWidths = "20,30,70,50,40,40,40"
.List = arrnew
End With
End With
End Sub
|
|