- Private Sub UserForm_Initialize()
- Dim Arr(), i&, j%, n%, x%, r%, c%
-
- n = 16 '多少列
- Arr = Range([g3], [g3].End(4)).Value
- With ListBox1
- .ColumnCount = n
- .ColumnWidths = "25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25"
- .ColumnHeads = False
- .BoundColumn = 0
- ReDim arr2(1 To Int(UBound(Arr) / n) + 1, 1 To n)
-
- '将1维数组转为2维数组
- For i = 1 To UBound(Arr)
- If i Mod n Then
- r = i \ n + 1
- c = i Mod n
- Else
- r = i / n
- c = n
- End If
- arr2(r, c) = Arr(i, 1)
- Next i
-
- .List = arr2 '赋值给listbox
- End With
- End Sub
复制代码
求助2b.rar
(13.44 KB, 下载次数: 20)
|