Delete an entry (row) in a userform listbox and update table on worksheet

Does anyone have a solution for this?

How do you populate the listbox list? using Rowsource? or directly from the table range?, something like like this:

Please Login or Register  to view this content.

I use rowsource.

listbox1 is populated with table1 and listbox2 is populated with table2. When I delete several rows from listbox1 it seems to shift all the rows up on listbox2

On my actual worksheet named "Tenders", my tables are in the same columns and placed beneath one another

I find using Rowsource unreliable if you plan to add or delete the list item (well, maybe I did it wrong).
So here's an example what I would do without using Rowsource:

Please Login or Register  to view this content.

Can you attach your sample workbook?

The sample workbook:

Thanks so much for your help, your code works perfectly. Would it be ok if I send you my userform to look at? I need help with some other codes for it as I am not very good with VBA?

You can attach your sample workbook (without sensitive data).
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

But if 'some other codes' you're referring to is different from your original problem than you need to start a new thread.

Ok thank you!

Could you look at the new thread I have just posted to see if you could help me with it?

Thanks

Akuini, the code is giving me a permission denied error70. Any idea how to fix this?

bakerman2, that's exactly what it was. I forgot to delete that

Thank you.

If you had a minute to spare could you look at my other post also about this userform?

appreciate your help