I put together a mini-search engine that works great. How it works is that it looks at the input provided by the user in cell "A3" on the "list" tab and then searches for a match in column A of the "Data" tab. All matches are then generated on the "List" tab beginning on row 11. To demonstrate input "blr", for example, in cell A3 on the "list tab". A list of matches should generate below. The code works as follows:
While the code works great on the worksheet, I can't seem to make it work with a userform. To see the userform I put together, click the button called "Userform". When the userform appears you will see that it contains a list box and a search bar - the same concept as the worksheet. That is, when the user inputs data in the search bar a list of matches should generate in the listbox in the same way as you see on the worksheet.Please Login or Register to view this content.
The user should then be able to select from one of the items listed and add it to "C11" using the "+" button for however many items needed. Any help would be appreciated.
Bookmarks