Filter listbox by value in textbox on userform

Hi Guys,

I am sure the solution is more simple that I am trying to make it but here is my problem!

I have a userform that holds a textbox called cboClientRef. The user is prompted to fill this in. I have a worksheet named Status with the ClientRef being the first column (A) for over 8,500 - many will be duplicated and thats what I need - with information that I need for each entry on the next 20 or so columns.

What I want to be able to do is have a listbox on the userform which as they user types the client reference number in the cboClientRef combo box, filters out only those records where the Client Reference number matches, and displays that along with the next 4 columns.

I would be very grateful for any pointers on this one!

Many thanks

Rob

Welcome to the forum!

I did that sort of thing in this code. Change sheet name, column count, and control names to suit.

In the Userform:

Please Login or Register  to view this content.

In a Module, paste and add references:

Please Login or Register  to view this content.