[ms office - 2010] Excel VBA code - listbox & search/find

[QuickIT]

Hi,

 

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...

 

Thanks

[pcstru]

You could be attempting to do this a number of ways, so posting the relevant code would be helpful.

[QuickIT]

Sorry, I meant to attach the document before.

 

The password to access the admin form through the 'User form' button is 2012.

 

Thanks

C Database - edited.zip

[pcstru]

You simply need to use a wildcard on your search string. So run the app and search for AB*. Now change the code to add the wildcard to the string.