Hi!

There has been a few threads about this, but none of them has really.

I have a listbox, which uses a textbox value to search items to the listbox. Then it should be possible to remove selected item from the listbox and worksheet by pressing a button.

Problem is, that when removing items, in the beginning it looks like it works but then it starts to remove wrong rows and from the worksheet and the selected item still is visible in the listbox.

Here are the codes

for filling the listbox

Please Login or Register  to view this content.
And deleting from the listbox

Please Login or Register  to view this content.
I have on another form a listbox, which gathers all names on sheet "names", from the range "names".

Please Login or Register  to view this content.
And I use to remove items from this sheet the following code:

Please Login or Register  to view this content.
And this seems to work just fine.

But when I use on the other form to fill the listbox using search to fill it, it doesn't seem to work. I've tried different solutions, but everyone seems to fail the same way.

Could anyone tell, what would be the best solution for this? If you've encountered the same problem and found a solution, it would be great to hear it!

Thanks!