|
本帖最后由 无聊的疯子 于 2011-9-7 13:04 编辑
回复 admin321 的帖子
复制进去替换了~
- Private Sub UserForm_Initialize()
- Dim ITM, arr, i%, j%
- With Sheets("资料")
- arr = .Range("B3:T" & .[B65536].End(3).Row)
- End With
- For i = 1 To UBound(arr)
- Set ITM = ListView1.ListItems.Add()
- ITM.Text = arr(i, 1)
- For j = 2 To 18
- ITM.SubItems(j - 1) = arr(i, j)
- Next
- Next
- Label2 = "共发现数据:" & ListView1.ListItems.Count & " 条"
- End Sub
复制代码
|
|