Show all data in spreadsheet via listview (VBA)

Hi i have a search facility on a userform that when you specify a column to search in and type part of a word into a text box it will bring up all the records in the spreadsheet that relate to the search via the list view.

However i want to be able to click a button to show all records in the spreadsheet in the list view.
this is my code for the search facilty.

Please Login or Register  to view this content.

Thanks in advance

L

Why are you using the ListView Control, I would think the ListBox would be sufficient & easier to code

You can show headings in a ListBox & I think you would find coding it simpler.

Attach an example workbook so that we can se what you have so far

listbox heading will only be present if you populate from a range reference.

You code uses .additem and appears to be finding specific items to add.