Search the list box "on the fly"?

Jaymond Flurrie

Well-known Member
Joined
Sep 22, 2008
Messages
868
Would anyone have a ready made code for Excel VBA to search the given listbox based on the criteria my user enters to a textbox? This shouldn't be hard to do but I can imagine people here have already implemented it several times so it's most likely well tested etc. already.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
How many columns in the listbox? If it's only one, then you can just use the Filter function in VBA.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,517
Messages
5,529,303
Members
409,862
Latest member
lbisacca
Top