Userform, show the last row before deleting it

[(T_T)]

Hello,

In a userfrorm I added a button to delete the last row of the data. I also added a MsgBox to make sure the user won't delete anything by accident.

Is it possible to show the last row in the message box so that the user can see what he/she is deleting? Or do I have to make a new userform to do this?

this is the delete button:

Please Login or Register  to view this content.

[davesexcel]

You can use textjoin()

Please Login or Register  to view this content.

[(T_T)]

You can use textjoin()

Please Login or Register  to view this content.

I get this error "error 438, object doesn't support this property or method" and this line is marked :

Please Login or Register  to view this content.

[davesexcel]

Okay,
It worked for me, can you supply the sample , possibly there is something amiss.

[sintek]

Please Login or Register  to view this content.

[torachan]

Why not select the last row with a listbox/combobox you can then view the contents and then delete.
play with the attached simple approach no search strings required, direct relationship between .listindex and row number.
torachan.

[(T_T)]

Please Login or Register  to view this content.

This Solved the problem
Thank you

[(T_T)]

Why not select the last row with a listbox/combobox you can then view the contents and then delete.
play with the attached simple approach no search strings required, direct relationship between .listindex and row number.
torachan.

This is really nice!
I want to add a edit button as well and this will solve both of them ＼（＾○＾）／
Thank you

[torachan]

Select your item from the listbox > alter data in textbox > update.
When you enter a new row first use the Clear button to ensure form is empty.

[sintek]

Glad to have helped...tx for rep +