Searching an array

[QWERTY]

Can someone tell me what is the fastest way to search something in a big array? For...Next statement doesn't work too good after array gets to big.
Thanks in advance

------------------
Visual Basic Programmer
------------------
PolComSoft
You will hear a lot about it.

[Mark Sreeves]

Are the elements of the array sorted?

------------------
Mark Sreeves
Analyst Programmer

[email protected]
A BMW Group Company

[Crazy D]

If the array is not sorted, walk thru it, element by element.
If it is sorted, you can start in the middle, check if you have to go to the 1st or the 2nd part of the array, then check the half of the part of the array that is left.
Or cheat, and use an invisible listbox, and use the API to find an item :-)