+ Reply to Thread
Results 1 to 3 of 3

Narrowing Results in ListBox using TextBox that Reloads when Backspace is Struck

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    Las Vegas, NV
    MS-Off Ver
    excel 2010, excel 2013
    Posts
    8

    Narrowing Results in ListBox using TextBox that Reloads when Backspace is Struck

    I currently have this code that uses a textbox to search through the populated listbox and removes any entries not matching the value in the textbox. It works great, but if the backspace key is struck it cannot reload the listbox and narrow down the results again.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Narrowing Results in ListBox using TextBox that Reloads when Backspace is Struck

    Reload the list with every change:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    06-26-2014
    Location
    Las Vegas, NV
    MS-Off Ver
    excel 2010, excel 2013
    Posts
    8

    Re: Narrowing Results in ListBox using TextBox that Reloads when Backspace is Struck

    Thanks! I can't believe I didn't think to do that...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Help] Narrowing search results prior to populating listbox
    By Compo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2013, 06:45 AM
  2. Textbox search and display results in listbox
    By AirBrun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-02-2012, 01:22 PM
  3. concatenate listbox results in textbox
    By rickdaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2012, 05:46 PM
  4. WebBrowser control reloads when switching worksheets
    By ngnw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2011, 03:37 AM
  5. Narrowing Data Listbox
    By playinpearls in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2009, 10:33 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1