I have a table like this.
jghAG.png
And after I search "abc_d" in "B5" it will show up like this
zqPPL.png
I want every time I search for "abc d" in the "B5". It will also understand that I'm looking for "abc_d".
This is my code in VBA for searching value by filtering column
Please Login or Register to view this content.
Thank you
Last edited by khoavutrantrieu17; 09-21-2023 at 01:14 PM.
Hi, try this
Please Login or Register to view this content.
If you click the autofilter arrow in B6, the value "abc d" will not appear as an option to select because it does not exist in column B. So why would you want to search for "abc d" if it doesn't exist in column B?I want every time I search for "abc d" in the "B5".
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
It worked. but this table is just an example. But when i change abc_d to abc_d efg with a space between d and e it will not worked. So is there any solution to this problem ? Thank you
So your example is not complete, place a relevant sample file pls
Does this work for you?
Please Login or Register to view this content.
Book1.xlsx
This is the complete example. And this is for:
_ Search data in Column A and B by Filtering with the code i upload on the top (Finish)
_ Whenever i search data in Column B. I want to make excel know that "space" when I search in "B5" equal to "_" in column B (exp: when i search "Apple Company ltd" in "B5" it also show every "Apple_Company ltd" value")
Thank you
You might be better off using the Worksheet_Change event rather than Selection_Change
Please Login or Register to view this content.
It worked. Thank u very much
Last edited by khoavutrantrieu17; 09-21-2023 at 01:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks