In this video, we will see how to display the search result in a list box on Userform Excel VBA. Feeding a Listbox. Filter a Listbox using multi-criteria with Combobox and Textbox. Perform intuitive searches.
This is absolutely awesome, there are very few that implement a userform for this type of search, that you can actually follow along and can tweak to get it into your own project. Thank you for you time in putting this out for the masses. Not sure why you didn't post the actual code as well, but that made for a better understanding
You didn't show how the header of each of the 9 columns is placed at the end of the video, we were left with the form without the header of the columns?
Excellent. You're great VBA teacher. Thanks for your best code and another useful tutorial. Your code works like miracle. All thumbs up. Already subscribed
good but could have been better and faster to work with the large table by using filtering the table using Wildcard(*) and coping the data to a temp sheet and then bringing the data in the list box with range. by converting the data in to the table it gives whole lot of functions to use for us and still keeping all the sheet functions also.
loved this! I'll test this on the project I am currently working on. Is it possible to conduct the search anywhere in the criteria? For example, if I type or, it will show the result of any word that has letters "or" and not just the one that starts with or?
vba excel, A1 type a few characters (if it supports Vietnamese, even better), B1 is the directory path to search, when found in B1 the word or excel file contains the same content as A1, then will return results from C1 down: the search path to the folder containing the word or excel file, the result contains content identical to A1 (including the file name). please help me