Use a button to control a macro that inserts an image into a shape or resets the shape

I have a worksheet with 4 rectagles that I created using the drawing tool. I am trying to write a macro that will allow me to use 2 buttons, one to insert a image into the predefined shape and another button to reset the shape back to the original default. In the attached workbook, I have a macro that kind of does what i want however, I do not like that if I cancel the "insert image" it dislays the error link to this post. If it is easier, i would be happy if the image was inserted in a box of merged cells as well.....either way accoplishes the task.

error.png

I am using the following macro:

Please Login or Register  to view this content.

But... I like how this one works: (thanks Steve...aka Nevets)

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


You just need to include the line

Please Login or Register  to view this content.

which will exit the routine if the dialog was cancelled.

Here is the code for first set of buttons

Please Login or Register  to view this content.

Add same code to other insert/reset buttons changing name of shape holding the image.

code in standard module to fill/reset shapes content.

Please Login or Register  to view this content.