automate auto filter?

[fua]

Dear all,

I have create a simple macro to filter data use criteria text filter and contains which reference to a cell, so when i click the Search button then will automatically filter data, I don't need to go to menu DATA=>FILTER=>TEXT FILTER=> SELECT CONTAIN=>and type the the text.
Reference cell: L1
Column to filter: H
Range filter:A1:I56846

Here is My script:

Please Login or Register  to view this content.

My question is,
How to modify the script which make the filter work when I just press ENTER after type the criteria in cell L1, so i don't need to click the button?

Many Thanks

[teylyn]

Hi,

you could put a macro into the sheet module for Worksheet_Change, test if the cell just changed is L1 and if so, call the Search() macro (or copy the complete Search() macro into the Worksheet_change and run it when L1 is the target cell.

hth

[fua]

Thanks, it solved using Worksheet_Change

[teylyn]

Great. Thanks for checking back.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save