Max number of loops

[StevePB]

Excel 97 VBA - I have a macro that checks lines in a file for a specific character before loading the lines into a list box. When the list is more than 255 lines, the macro hangs (tested on two PCs - NT4 and Win98). I am using the follwing code to loop through the lines:

[tt]for i = 0 to listQuantity[/tt]

...do some stuff

[tt]next i[/tt]

I've tried using a do loop with the same result. Is there a maximum number of loops ? is there a work around ?

 

[Jon4747]

Hi StevenPB

The problem isn't with the macro or the loops its the listbox property. The max. number of lines in a listbox is 256 (0 - 255). Your macro is trying to write to something that doesn't exist.

Jon

 

[kevinclark]

Just out of curiosity is this a limitation of Office 97 ?
I have Office 2000 populating a listbox with 1000+ lines.

 

[StevePB]

Thanks for your help Jon.

Any suggestions for an alternative? (upgrading to Office 2000 is not an option in this case).

Am I stuck with disabling scrolling, and using page up/page down buttons to rebuild the list? This is frustrating as the list only occasionally exceeds 255 lines.