Search the list box "on the fly"?

[Jaymond Flurrie]

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.

 

[RoryA]

How many columns in the listbox? If it's only one, then you can just use the Filter function in VBA.

 

[Jaymond Flurrie]

How many columns in the listbox? If it's only one, then you can just use the Filter function in VBA.

Yeah, only one. That was fast, thanks!