Delete Shape and Row

**eblaze** · 05-19-2010, 11:44 AM

Hi all...

First post here, so I hope someone can help me out.

I essentially have a button called "Remove" which I would like to delete the row it's on. I have figured out how to delete the button on click but can't get the click of this button to also delete the row of data. It's driving me up the wall.

Any help?

**davegugg** · 05-19-2010, 12:06 PM

Does the button name or caption somehow identify which row it is on?

**eblaze** · 05-19-2010, 03:03 PM

Dave,
The button does not identify the row. I have simply added it next to the last piece of data on the row.

I have an additional "Insert" button that creates a new line and copies a preformatted dataset including a new "Remove" button.

Thanks

**davegugg** · 05-19-2010, 03:21 PM

When you add the Remove button, what name do you give it? It may be possible to add a suffix to the end indicating the row number. You could then use that suffix to delete that row. Could you post the code that runs when you click the "Insert" button?

**snb** · 05-19-2010, 03:47 PM

to remove the last row

Please Login or Register  to view this content.

**Tom Schreiner** · 05-19-2010, 04:53 PM

Shape objects expose a couple of methods such as TopLeftCell and BottomRightCell. You can use one or the other or both to determine the range that contains (or intersects) the shape. What type of button have you drawn out? ActiveX from the ControlToolbox? A forms button? A shape from the drawing commandbar? It does not really matter as all of these different types of objects can be referenced by the shape class but it does matter in how we might go about getting a reference to the button itself. Are you able to upload an example here???