Hi all. one more question.
Are strArrays limited to 32768? What if I have say 50000 things?
ANybody know?
Thanks
Wengang
Printable View
Hi all. one more question.
Are strArrays limited to 32768? What if I have say 50000 things?
ANybody know?
Thanks
Wengang
just use 2 arrays instead, it will be twice as much code, but it will work
Code:Option Explicit
'this is not 50,000 it is 500,000 and no problem
'however a listbox is limited so you can only
'exhibit 32,736 items as that is where the list box will klunk out
'however if you just ask for myArr(499,000) the element is in the array
Private Sub Command1_Click()
Dim myarr(500000)
Dim i
For i = 1 To 500000
myarr(i) = i
' List1.AddItem myarr(i)
Next i
List1.AddItem myarr(489000)
End Sub