Microsoft Office 2000/Visual Basic Programmer's Guide

Searching an Array

When you need to determine whether a particular item exists in an array, how do you do it? You can loop through the array, checking each element, until you find what you need. However, this method, though obvious, is inefficient. The following sections present alternative ways to search an array.