有原文件!
Private Sub CommandButton1_Click()
Unload Me
End Sub
Private Sub abc_Change()
Dim ITM
Dim arr, i%
Me.abd.ListItems.Clear
With Sheets("数据库")
arr = .Range("a2:K" & .[a65536].End(3).Row)
End With
For i = 1 To UBound(arr)
If arr(i, 1) Like "*" & Me.abc & "*" Then
Set ITM = abd.ListItems.Add()
ITM.Text = arr(i, 3)
ITM.SubItems(1) = arr(i, 1)
ITM.SubItems(2) = arr(i, 4)
ITM.SubItems(3) = arr(i, 5)
ITM.SubItems(4) = arr(i, 6)
ITM.SubItems(5) = arr(i, 7)
ITM.SubItems(6) = arr(i, 8)
ITM.SubItems(7) = arr(i, 9)
ITM.SubItems(8) = arr(i, 10)
ITM.SubItems(9) = arr(i, 2)
ITM.SubItems(10) = arr(i, 11)
End If
Next
End Sub
Private Sub UserForm_Initialize()
With Me.abd
.ColumnHeaders.Add , , "凭证号", .Width / 11.5 * 1
.ColumnHeaders.Add , , "工单号", .Width / 5 * 1
.ColumnHeaders.Add , , "产品编号", .Width / 6.5 * 1
.ColumnHeaders.Add , , "名称规格", .Width / 4 * 1
.ColumnHeaders.Add , , "模具型号", .Width / 8 * 1
.ColumnHeaders.Add , , "订单数", .Width / 11 * 1
.ColumnHeaders.Add , , "转交数", .Width / 11 * 1
.ColumnHeaders.Add , , "送货数", .Width / 11 * 1
.ColumnHeaders.Add , , "签收人", .Width / 11 * 1
.ColumnHeaders.Add , , "签收日期", .Width / 7 * 1
.ColumnHeaders.Add , , "备 注", .Width / 7 * 1
.View = lvwReport
.FullRowSelect = True
.Gridlines = True
End With
Dim ITM
Dim arr, i%
With Sheets("数据库")
arr = .Range("a2:K" & .[a65536].End(3).Row)
End With
For i = 1 To UBound(arr)
Set ITM = abd.ListItems.Add()
ITM.Text = arr(i, 3)
ITM.SubItems(1) = arr(i, 1)
ITM.SubItems(2) = arr(i, 4)
ITM.SubItems(3) = arr(i, 5)
ITM.SubItems(4) = arr(i, 6)
ITM.SubItems(5) = arr(i, 7)
ITM.SubItems(6) = arr(i, 8)
ITM.SubItems(7) = arr(i, 9)
ITM.SubItems(8) = arr(i, 10)
ITM.SubItems(9) = arr(i, 2)
ITM.SubItems(10) = arr(i, 11)
Next
End Sub
|