Excel VBA code - listbox & search/find
I'm building a userform on an Excel database and have come across some problems.
I've got a listbox that displays records from the database when searched for in the customer name text box on the form. Unfortunately, you have to search for the full customer name for it to recognize and return the data to the listbox. I need help to edit the code so that you can either search for full or part customer name. (the reason you have to search for full customer name is that it uses the autofilter function!)
The way the listbox works is to display records for customers if there is more than under the same name.
I look forward to hearing your replies...