Hi Nate,

Alternatively, and perhaps more simply:

- replace the ListBox with a ComboBox
from the Control Toolbox

- dispense with the code in the worksheet
module

- replace the code suggested for the
standard module with the folloing version

Now, using the ComboBox's MatchEntry
property, as the user types each letter, the
control will sugggest a value.


---
Regards.
Norman