|
楼主 |
发表于 2016-3-14 20:18
|
显示全部楼层
Private Sub UserForm_Initialize()
arr = [a1].CurrentRegion
ReDim brr(1 To UBound(arr) - 1, 1 To 4)
For i = 2 To UBound(arr)
brr(i - 1, 1) = arr(i, 1)
brr(i - 1, 2) = arr(i, 3)
brr(i - 1, 3) = arr(i, 4)
brr(i - 1, 4) = arr(i, 6)
Next
ListBox1.List = brr
End Sub
|
|