Hello guys
In fact, my topic is different from the rest of the usual topics, and I certainly did not find any topic like mine. What I searched for is that all the elements are not selected should delete them , provided that they are before the selected element. As for the not selected elements that locate after the selected element, they must remain as they are without deletion .
note: it must just delete from listbox ,not from sheet
here is my file to see closely
DELETE .xlsm
first picture whether show the data on userform or search by textbox
second sheet when select specific item
then should delete all of items before selected item from listbox, should not delete from sheet at all .
thanks in advance .
In fact, my topic is different from the rest of the usual topics, and I certainly did not find any topic like mine. What I searched for is that all the elements are not selected should delete them , provided that they are before the selected element. As for the not selected elements that locate after the selected element, they must remain as they are without deletion .
note: it must just delete from listbox ,not from sheet
here is my file to see closely
DELETE .xlsm
first picture whether show the data on userform or search by textbox
second sheet when select specific item
then should delete all of items before selected item from listbox, should not delete from sheet at all .
thanks in advance .