Hi,
I Have user form as below:
Textbox1
Listbox1
I would like to build the search query where, when type the keyword, the list box items reduce to match the keywords.
appreciate your help
regards
VJ
Hi,
I Have user form as below:
Textbox1
Listbox1
I would like to build the search query where, when type the keyword, the list box items reduce to match the keywords.
appreciate your help
regards
VJ
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Greetings Ford,
Uploaded the file for your help.
e.g. if I type "Gift" in the text box, the list box only display gift items.
Try this one.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you very much Ford ... really appreciate it
*
Ford... Noted that you are referring the excel sheet1 for reference. can help to point the reference to the Listbox instead?
Please Login or Register to view this content.
Last edited by FDibbins; 03-17-2017 at 02:21 AM.
Ford ??????
Ho Ford,
I want to do the filtering based on Listbox.
Please Login or Register to view this content.
Last edited by FDibbins; 03-17-2017 at 02:21 AM.
Ford,
I hit error when try to run the script.... really appreciate your help
regards
VJ
Please use Code Tags when posting code according to Forum Rule#3
Please try to understand the code before you start making changes to it. Code from Post#4 works just fine.
Also remove RowSource from ListBox Properties in order to make code work.Please Login or Register to view this content.
Last edited by bakerman2; 03-17-2017 at 02:17 AM.
I think you have me mixed up with bakerman2, he is the 1 that is providing the assistance
Also, please note that when posting code, use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
(I have added them for you in your previous posts)
Thousand apology,
ops.... sorry and thank you very much guys... Ford & Bakerman2 .. I got mixed up.. hahahahaah
BTW, my full project will looks like as attached file. I'm working out a specific keyword search engine.
Every category are unique and the search should be within the particular category.
For example
1. First user must determine the Main category : Bulk or Form
2. From this they determine sub category e.g. Bulk - Goods, Bulk - Services or Form - Goods, Form - Services
3. When they select the sub category, the user form will list down all the items under that category only
4. Then they can use the text box to do key word search within the sub- category items.
Regards
VJ
Last edited by cupid800429; 03-17-2017 at 05:05 AM. Reason: Missed Attachment
Try this for Bulk page.
Please Login or Register to view this content.
Looks better, but i'm unable to backspace and continue with new search within the same sub category.
Try this, done it for Bulk - Loan & Bulk - Investment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks