Populating listbox

I managed to make userform with search textbox and listbox to display the search result
the current case is that the search result of search textbox "TextBox26" (the first 10 columns of the table in DT sheet ) are displayed in the listbox1, if textbox26 is clear then the listbox is clear
what i need is that all the record are displayed in the listbox by default and then the search box only filter the record displayed in the list box
i mean when the search box is clear the listbox displays all the records and the search box is used to filter this records

the code in the search box "TextBox26" is as follow

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.