Adding/removing the delete button automatically to a database in table

[dmbroekhuysen]

Hi all!

I've been working for a while on a tool with a database library that allows the user to add new entries. My database library is in table format and I would like it to also have a 'button' or 'cross' that allows the user to delete an entry with a single click followed by a userform that asks the regular annoying 'Are you sure' pop-up.

Now I do know how to insert this macro by recording for each single row, what I would like is for these buttons to be added to the table with each new entry automatically and to be removed when the entry is removed.

Can anyone help?

[LJMetzger]

Hi dmbroekhuysen,

What you want can be done, but requires a button for each item.

As an alternative, I suggest 'Double-Clicking' any item in the table. See the attached file which is a simple implementation of the 'Double Click' idea.

Lewis

Sheet1 module code:

Please Login or Register  to view this content.

[dmbroekhuysen]

Hi LJMetzger!

Thank you for your contribution! After modifying it a bit I managed to implement it to my file and successfully delete the selected row using the double click function. All I had to change was the action taken after iReply = vbYes, which is not just a messagebox but also deleting the row using the code ' Selection.Delete Shift:=xlUp'.

Thanks again!