Excel VBA Userform database search - Advanced Filter

Hello..

I am having few issues with regards to the results of the Advanced search VBA. Hope you can assist me with this problem.

This is a simple userform with a text box and a list box. The aim is not to match all the case, but to search the data for any match and then display the rows of the matches. For example if I search for "Ex", the result would display all rows of the data that have somewhere in the row words similar to "Ex" such as "Excel", "Example" .... Please see attached excel to help understand better.

THE PROCESS:

1. The user types in the text box what to search for,
2. The value of the textbox is sent to "L9" cell in the workbook
3. An advanced filter runs that searches the available data for the value of cell "L9" and then pastes the filtered results in the allocated range.
4. The listbox mirrors the results in the allocated range.

All seem to work well and perfect. Except when the search is done, if a match is found in a specific column "E", it does not carry on to search all the remaining columns and only gives the results found in that column.

Example: in the attached excel: We have the word "TEST" in four cells: B14, D12, D13, F15 & H17 - When we search for the word TEST and run it, it only gives the following results: D12 & D13 (That is Row 12 & Row 13) - it does not look in other columns.


Please advice on this issue.


Thank you

Best Regards
Amir

Amir,

doesn't give result ? or not all ?

Not all could be because it is Case sensitive, so Example is not the same as example or EXEMPLE


Kind regards
Leo

Shame on me, forget 1 column

Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Kind regards
Leo