Userform select last entry and delete them

Hi

How can I chose the last 2 cells in 2 columns and delete them?

I created a userform, which saves the data either in column D and E or Column D, E and F, depending on the user's choice. Now I want to add 2 buttons (for each choice) that will delete the last entry.

other columns are filled and the row shouldn't be deleted.

Assuming you meant Tabelle2 from the attachment in your other thread, this will delete the values from the last populated row in D:E

Please Login or Register  to view this content.

And this the same from D:F

Please Login or Register  to view this content.

Is that what you meant?

BSB

Try this:

Please Login or Register  to view this content.

BSB

Originally Posted by BadlySpelledBuoy

Try this:

Please Login or Register  to view this content.

BSB

It's the same when I click on yes nothing happens

I see the whole code you've added?

BSB

I just realized that I didn't change the sheet name (*∩~∩)

it works fine
thank you

Excellent news. Glad I could help.

BSB