Show shape on cell select, Hide shape when cell is deselected

Rename your shape by selecting it and type in name box "MyShape" then
In worksheet module put the code

Please Login or Register  to view this content.

Hello brendangroff,

You can do much better with only selecting Cell A1, by adding a Dropdown Box, and then select any image of your choice.

Please try the attached sample Workbook, and see if you can make it work for you. If you have any questions, just ask.

Regards.

You're welcome. Glad I can offer some help
Please mark the thread as solved

Hi brendangroff,

Glad you like it, you are welcome.

Thank you for the feedback, and for adding to my Reputation. Much appreciated!

Regards.

@ YasserKhalil,

Your PM Inbox is full and as such does not comply with my Friends Rule No. 4c, Chapter 3, Clause 5.b, Section 5 of Chapter 2!

Until you abide to that Rule as stipulated above, and you do not Empty your PM Inbox, I shall be compelled to not send you any PM's.

Please consider this as a Final Warning!!!

Thank you.

Edit: This "Moderation Request" may now be ignored, as YasserKhalil complied with "My Rules"!

@Winon
I can't object you and according to Rule No. 4c, Chapter 3, Clause 5.b, Section 5 of Chapter 2! Item number 1!!
I did it and empty the box to avoid any warning ..
Thanks for your coming PM
Regards

@ YasserKhalil,

Things in general are far too serious and clinical in the most of the Forum topics, and besides the Water Cooler, I thought it would do no harm in relaxing things up a bit here as well.

You now have a PM from me. Thank you.

@ zplugger,

I do admire your inquiring mind and keen interest in the solutions provided in this Forum.

If you look at the Code of the sample Workbook I have posted, you will see that there are three pictures. Picture 1, Picture 2 and Picture 3. These pictures are placed randomly anywhere on the Sheet you would be working with. In Column N which is hidden, I have "attached" a name to each of the three pictures, using VBA code. In Cell A I created a DropDown list based on the values in the hidden Column "N". From there the Code takes control, and if Cell A is empty, all pictures are hidden.

Now, when you select a "Name attached" to the picture in Cell A, that picture will show where it is placed on the Sheet. You may leave it where it displays, or if you like, you may click on the picture and drag it to where you want it. In the sample Workbook for instance, I have dragged each Picture to the same area/Cell where I want it to show. The pictures are now stacked upon each other, while hidden, until you select a "Name" in Cell A, and only then that picture will show.

Apologies if the above is as clear as mud. Should you require more information, please just ask.

Regards.