arrys = MySht.Range("F2:F" & MySht.Range("F65536").End(xlUp).Row) If IsArray(arrys) Then For Each Temp In arrys d(Temp) = 1 Next Else d(arrys) = 1 End If
Sub 列表框显示() Dim i As Long Dim j As Long On Error Resume Next UserForm2.ListBox1.Clear UserForm2.ListBox1.ColumnCount = 8 With Sheets("结果显示") .Range("F2:F" & .[A65536].End(3).Row) = .Range("F2:F" & .[A65536].End(3).Row).Value '转化为数值 For i = 1 To .[A65536].End(3).Row UserForm2.ListBox1.AddItem For j = 1 To 8 UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, j - 1) = .Cells(i, j) Next j Next i UserForm2.ListBox1.ColumnWidths = "52;52;42;108;25;28;26;40" UserForm2.TextBox3 = WorksheetFunction.SumIf(.Range("F:F"), ">0") '进库 UserForm2.TextBox4 = WorksheetFunction.SumIf(.Range("F:F"), "<0") '出库 UserForm2.TextBox5 = WorksheetFunction.Sum(.Range("F:F")) '库存 End With End Sub