Search Results displayed in a Listbox

Hi everyone,

I've got a listbox set up on a userform with one textbox. What I need to happen is that the moment the user types in something into the textbox, a search is made in a worksheet using those characters. When a match is found, the first 11 columns of that row be displayed in the listbox. The search then continues to search the sheet to find additional matches and lists those rows if found.

The problem is that the listbox should empty and update with each character change. So I guess the VBA code with have to sit in the textbox_change sub.

What I am trying to achieve here is a list of results that are narrowed down the more the user types. They would then be able to double click the line they need in the listbox to go to a userform with more details about it.

Can anyone please help me with this? I am not quite sure how to search and list results in this way.

Originally Posted by royUK

See the DatabaseForm example

Thanks Roy, I'll take a look. Can't download anything right now though until I get home.

I had to put this to the side temporarily so sorry for picking up again.

The example you gave link to was close to what I was after. In the end I am toying with the following code i found here

But now I have a further problem. I keep getting an error message saying "Could not set the list property. Invalid property value". The following line highlighted is

Please Login or Register  to view this content.

I am using a 2 column listbox. The characters entered in textbox 1 should _change trigger the search to look in range I2:I797 and list all matches in column 2 of the listbox with column one displaying column G of the corresponding row for each result.

My code so far is:

Please Login or Register  to view this content.

Can anyone please help me?

Thanks Roy, Your code prevented the error message, but now as I type in the textbox, no results are listed at all and I'm not sure why. Any found results should be listed from the specified range in column 2, and in column 1 the respective value in same row but column G.

Please Login or Register  to view this content.

Originally Posted by Julesdude

Certainly, here you go.

Not sure why the above file is that large but anyway, it demonstrates the form I'm working with and accompanying code. I just can't get it to bring up what I need - a list of strings in the specified range which contain the characters entered in textbox 1.

Bumpety bump. Anyone able to help?