+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Excel VBA code - listbox & search/find in Technical; Hi, I'm building a userform on an Excel database and have come across some problems. I've got a listbox that ...
  1. #1

    Join Date
    Oct 2012
    Location
    North West England
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Excel VBA code - listbox & search/find

    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

  2. #2


    Join Date
    May 2009
    Posts
    2,878
    Thank Post
    258
    Thanked 767 Times in 582 Posts
    Rep Power
    269
    You could be attempting to do this a number of ways, so posting the relevant code would be helpful.

  3. #3

    Join Date
    Oct 2012
    Location
    North West England
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Sorry, I meant to attach the document before.

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

    Thanks
    Attached Files Attached Files

  4. #4


    Join Date
    May 2009
    Posts
    2,878
    Thank Post
    258
    Thanked 767 Times in 582 Posts
    Rep Power
    269
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Find a file in excel VBA
    By Stuart_C in forum Coding
    Replies: 15
    Last Post: 10th May 2011, 03:10 PM
  2. VBA Code to copy all form updates to one form
    By acrobson in forum Coding
    Replies: 2
    Last Post: 27th January 2010, 07:04 PM
  3. Excel VBA Issues
    By dataoverride in forum Coding
    Replies: 5
    Last Post: 23rd September 2009, 02:16 PM
  4. Excel VBA problems
    By cursong in forum Coding
    Replies: 1
    Last Post: 13th October 2008, 11:28 AM
  5. Excel VBA Loop Question
    By vunsev in forum Coding
    Replies: 5
    Last Post: 11th April 2008, 08:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •