Search any text in excel lists.

[prasjohn]

Hi All, I have a sheet with list of terms, i simply want to search for any item, and while i enter the alphabets, i should get all the results that "contains" that combination. Minimum letters that should be entered is 3, which means, if user enters only 2, it will search at all.

please find the attached sheet for further reference. Thanks in advance,

OR: Using VBA, is there a way to pass a variable to a filter ?
I'd like to create a model with a filter where MyVar = "MyTxt". Then the user runs the code, and inputs the value for that variable, say Abc. Then MyVar= Abc is passed to the filter so that MyVar= Abc. In effect, I should have a filter(with "contains" funcion) with the text that i am entering in a cell.
Any help will be highly appreciated.

[venkat1926]

take a cell any where. if you are going to choose cell in column B take a few rows below the database for e.g. B12
so B12 is the pivotal cell
I have given you an event code below. if the pivotal cell is not B12 change the relevant statemnt in the event code

right click the sheet tabl and click view code and copy this event code

Please Login or Register  to view this content.

now do this experiment
1.type rro in B12 and hit enter key see what happens to the next two cells to the right
you will get 6 and 7
2.now type pha in B12 see what happens. you will get 4
3.type get you will get 5
try with various experiments.
This will be more convenient way of doing it.


I am returning the file where the event code is already paraked in sheet code. The name of the file is prashohn.xls
Your can start doing the expriemnt 1,2,3 etc given above.