Creating a Button with VBA that can delete itself + the Row it's created on

[ALoelke]

I am automatically generating rows on my Excel with user input data from a form
They click a button, it pops up the Form, they fill in their data and it adds it to the rows.

With this I want to create a "remove row button" at the end of these inserted rows.
that the button when clicked will remove the row and the button.

Declared variables

Please Login or Register  to view this content.

I create the rows

Please Login or Register  to view this content.

the data fills into the rows from all the user fields...

I then create the button

Please Login or Register  to view this content.

This lands it in the 9th Column of the Row I just created
I currently have OnAction set to do nothing, just so it doesn't error out

but I have tried setting the OnAction to remove the button itself

Please Login or Register  to view this content.

but it errors out, as I am not sure what is off with this.

I also tried setting the OnAction to delete the Inserted Row it was created on, but couldn't get that to function either.
and I need the created button to do both actions.
As later on I want to lock the excel, and leave these generated buttons as the only way to remove the rows they create.

[TnTinMN]

Hi ALoelke and welcome to the forum. Please wrap your code fragments with code tags. You can do this by clicking the '#' button on toolbar and then pasting your code. You can also select your code and clicking on the '#' button.

I believe that the following subroutine will do what you want if you set it to the OnAction property for your button.

Please Login or Register  to view this content.

Please Login or Register  to view this content.