Hi- this is my first post, so please forgive any mis-steps. I have managed to scrub this forum to find enough examples to build a new form from scratch that does a whole bunch of stuff (I'm new to all of this), so thanks to everyone who I have lifted code from so far!
Here is one I just can't seem to find an answer for:
I am creating a form with a table, I do not want my users to have to use any excel navigation (assuming little to know excel knowledge for users) to add or remove rows from the table.
I have created a button at the bottom of the table which will add a new row to the end of the table. This is all working fine.
I would like for my user to be able to remove a row they had previously entered by clicking on a button residing on the particular row that they want to remove. Basically the same action they would get by going to the row header and deleting.
So my first question is if I can have each new row that is added to the table contain the delete button (as shown in my attached example where I have attached some "dummy" buttons for illustrative purposes)?
Second question, assuming the first is possible, how can I attach a macro that will delete that specific row (the one being clicked on)?
Hopefully this explanation along with the attached file (simplified version of my table) will help clarify what I am trying to do.
Thanks in advance for any help!
Bookmarks