Is there anyway to have all records that match a criteria shown in a list box.


Here is my idea of what I think I need.

I have a textbox (TextBox1). A user will put in a search word and hit a command button

The procedure will

1. activate Sheet1 (has all the records)
2. Loop through all the records (row 1 - column b, until empty, no blank rows in middle)
3. Every record that has part of the search criteria in it (ex. Jones) would be able to be displayed in a listbox, with it showing the full name (column b) as well as column c. So the listbox would have a columncount of 2


My problem is I don't know if another sheet is needed to put all the criteria on the new sheet, and have the listbox just read from the new sheet.


Thanks for any help


Josh