SEARCH RESULT DISPLAYED ON LISTBOX

I've posted several example of UserForms that do this.

I can't help with an image, attach an example workbook containing some data and your UserForm.

My web site also has examples.

Quote from royUK

I've posted several example of UserForms that do this.

I can't help with an image, attach an example workbook containing some data and your UserForm.

My web site also has examples.

Hi royUK

I think the link to the Advanced DataBaseForm on your website is broken

Thanks

Jorge

No it's not available at the moment. I'm updating it. Attach an example of your workbook

OK thanks.

I will be waiting for the update of your example.

I apologize for meddling in this topic.

Thanks

Jorge

Try zipping the file

I've worked on this previously.

I would suggest that you replace the TextBox with a ComboBox so that the the user cannot enter parts that do not exist.

I'm looking at it now.

Try this

I think the size of your sample file is causing problems with the attachment

Pleased to help.

Post back if you need further help.

Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.

The best way would be to sort the data on the sheet - TransID - High to Low then load the ListBox

This solution solves one problem for you, but adds another one, that is, the date problem I think is solved, but by this method the column headers disappear, it is an EXCEL / VBA fault.

The solution is to put a label, for the headers, otherwise the solution is just as RoyUK says.

Sorting data should not affect the ListBox. I was referring to sort the source data, there's no point sorting the ListBox itself

I've added code to sort the IN_OUT sheet to show the latest record first.

I can't really understand what you are doing, there seems way too many operations in your userform than necessary.