Returning search from textbox and combobox conbined

Afternoon,

I have a list box that I can search for from either a TextBox or a ComboBox, but I want to do a multiple search with entries in both boxes and return the corresponding data from the data sheet, Textbox1114 looks at column B (date) and Combobox3 looks at column H (Haulier), so I need to return the data for a haulier on a certain date...

Hopefully someone has a solution to my little problem, the code below runs the serach of the datarange and returns the search criteria but onlu based on the one text/combo box.

Please Login or Register  to view this content.

Thanks in advance for your help

Reg

Here is what I came up with. You need to change the format of data in column B to "Date".

Please Login or Register  to view this content.

I tried to preserve as much of your code as possible, but it could be cleaned up a bit. You may want to look for ways to not jump around with GoTo as much.

Cfr. the attachment

It worked on your sample workbook. Perhaps you could post a new workbook that demonstartes the "freeze".

SNB's suggestion doesn't work, it will list to the sheet but not into the listbox,

My suggestion works, but you don't.
You may adapt my suggestion to populate the listbox.
Can't be too complicated...(a one-liner)

It isn't working for haulier1 because you don't have any SHUNTERs called haulier1; they are called Haulier1. I would suggest populating combobox 3 with values in Data column H instead of hard typing them.

Originally Posted by snb

My suggestion works, but you don't.
...

snb.... please watch it. We don't treat our visitors with that kind of disrespect here!