searching a list box

[mghdb]

Hi all,
Does anyone have any ideas how to search and find function on a lengthy list box. I have a list box that contains 500 records, I would like to have the user type in a specific record and that record would highlight and be selected. I've tried converting the list box to combo box, but the combo box is not what i really want to use. Any suggestion will be helpful. Thank you

 

[llkhoutx]

Specify the text to be located in a separate text box, then on event OnExit, use VBA code to search the list box column for a match with the text box and then set a bookmark on that record.