Identify button (shape) row to insert row and delete row

I have a button (group containing and add and delete button).
I want to identify the row (position of shape/button calling the macro) to enable inserting a new row (1 row down from current row).

Then do the same to delete a row (position of shape/button calling the macro) to enable deletion of selected row.

This will allow me to add/insert rows by the button located at that row

The problem i have is getting the row property (row position of the button eg. TopLeftCell.Row) of the add button. The add button (RowBtnAdd) is a shape within a group (BtnGrp)

I also note that when a group is copied, it has the same shape name as that copied.
I want to keep the add and delete shape within the group (BtnGrp).
I do not want to select a cell or row or enter a row number to delete etc.

refer to sample workbook attached. Currently only has one record row.

code so far -

Please Login or Register  to view this content.

Any help would be much appreciated.

The application.caller returns the name of the Add button but that does not exist in the Shapes collection. The grouped item is what is in the collection.

You can use the groupitems collection to determine whether the caller is in that group. Obviously your problem comes when all the controls have the same name. There is no way of determining which group the button belongs to.

You would need to give each control within the group a uniqe name.

Looks like a muddle up a couple of threads.

try this code.

Please Login or Register  to view this content.

Hello,

This code is perfect for what I want to do !! That's exactly what I need !

But when I try to use it in another file, with several columns wich include formulas, I have an error 1004. VBA tells me that this comes from this line :

Sub UpdateNames(MyGroup As Shape)
(…)
For Each shpTemp In MyGroup.GroupItems

Edit : the file I uploaded show the error when you click on add buttons and add text or formulas in columns.
I tried on Excel 2007 and 2010.

Do you have any idea please ?
I really need this code to work for my personal project !

Thanks a lot for every suggestion .

(yes, this is an old post but that's the only code on the interne that seems to add/remove rows with buttons. If you know anything else like this, I will look at it )