title: VB6: How to search an array fast?
body: <p>say, i have a string array of 50000 elements. Searching the array using <code>For Next</code> is so slow for such a huge array. Is there any fast way to search?</p>
  
  <p>Note: Using <code>join</code> &amp; <code>instr</code> we can search for a string in an array, but this method is no good as i can not find out the element number</p>
  
  <p>Note: the array is unsorted. And i'm looking for substrings</p>