|
发表于 2011-9-22 16:56
|
显示全部楼层
本楼为最佳答案
- Private Sub UserForm_Initialize()
- Dim Arr, i&, k&, j As Byte
- Arr = Range([g4], [g4].End(4)).Value
- With ListBox1
- .ColumnCount = 6
- .ColumnWidths = "30,30,30,30,30,30"
- .ColumnHeads = False
- .BoundColumn = 0
- For i = 1 To UBound(Arr, 1) Step 6
- k = k + 1
- .AddItem
- For j = 1 To 6
- If i + j - 2 < UBound(Arr, 1) Then .Column(j - 1, k - 1) = Arr(i + j - 1, 1)
- Next
- Next
- End With
- End Sub
复制代码
求助2.rar
(12.98 KB, 下载次数: 25)
|
|