Remove a shape with user selection

[jeff_kaufman]

I have multiple buttons on a worksheet. Under some of the buttons is an oval or rectangular shape. When the user selects a button I am removing any text from the button and making the button not visible.

I also want to delete the oval or rectangle shape that is at the location of the button.

The following code runs and does not error out - everything works except it does not find the oval or rectangle in the range specified. Thoughts? Suggestions?

Please Login or Register  to view this content.

[Norie]

Jeff

Have you tried stepping through the code?

Then you can see what's happening, or, in this case, not happening.

[jeff_kaufman]

I have stepped through it but I am not getting why the code is not picking up the shape. Could it be the range of cells it is looking in does not have the "topleftCell" of the shape in it?

[jeff_kaufman]

OKAY - the code above actually works. The if statement was not looking for the proper text (there were spaces in the text).... so idiot programmer mistake - sorry for the bother.

[Norie]

Jeff

I actually thought that might be the problem but had no way to test.