Modify my SEARCH userform from 1 return to multiple returns if needed?

Hi,

I created this search userform with help from various people from this forum and it works great but recently a problem has arisen that I now need it to be able to return multiple answers.

So basically at the moment the userform finds the first order number matching the order number entered into the search userform and then fills out the fields to suit.

On the Changeover Form sheet, the last few order numbers I have changed to 12345678.
What I would like is when 12345678 is entered into the search userform it returns all 7 entries.
A maximum of 10 returns should be enough.
I appreciated I will have to change a lot of things around or even start again, which is fine. I would just like someone to point me in the right direction in how to get started and what is the best way of doing this.

Any help on this would be much appreciated.

Kind Regards

Dan

Search Button populate ListBox
Click On Listbox populate textbox

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,

Thank you so much for the modification you have done. Unfortunately it has come up with run time error 9 when I entered the process number 22544880.

Any chance you could take a look at it please?

Also if I may be cheeky, there are a couple of other things I'd like to add/change if that is ok?

If so, I don't need the row number showing in the list box, can I have the date&time instead please and when I press the clear button, can I have it that it clears the list box as well please?

Thank you again for all you've done, it really is appreciated.

Kind Regards

Dan

With modifications, row numbers still present but not visible
you need those to polulate textbox

Kind regards
Leo

Hi Leo,

Thank you for the changes but there is just one more thing, if that's ok?

Please can I have the date in the Listbox the same format as the date in the Textbox?

Thank you again for all you have done.

Kind Regards

Dan

In Code CommandButton1 change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,

That's brilliant, thank you for all your help.

Kind Regards
Dan