Filter listbox to selected items

[Undo]

Hi

With userform1 listbox1, can I add command button1 to filter listbox to show only selected items, and another button2 to clear filter without unselect selected items?
listbox using rowsource
is that possible?

or show it in new listbox? or any other idea? "no need to show it in msgbox"

[torachan]

with the attached demo - filter with option buttons first - this loads the combobox with appropriate column which selects appropriate row of listbox.
there is a textbox overlaying the combobox if you type in the relevant item after selecting the option button (column) - the listbox will go to the selection.
selecting from the listbox fills the five text boxes - the listbox is loaded via an array from the table - rowsource is best avoided at all times.