Stacking Pictures When Cell Conditions Met

[kgall89]

Hello All,

I have a series of pictures that I would like a macro to populate pictures dependent on a cell value. I would like these pictures to stack on top of each other to create a composite picture.

Attached is a sample of my workbook, I am not sure this is feasible but I figured I would ask!

I have tried using an indirect function but am having issues with the overlay and sizing.

Thank you for your time and any feedback, let the know if you need any more info!

Kyle

[davesexcel]

You can use a worksheet_change event to make the pictures visible.
This example I have the target address as C1, when you select from c1, the pictures will become visible or hidden.

Please Login or Register  to view this content.

NOTE:

I forgot to mention, I named the pictures as well.

[kgall89]

Thank you very much davesexcel, This is very helpful.

I have successfully recreated the outcome on my worksheet, I do have two follow up questions:

1. Can I have the target address on another sheet? I have tried to add in the name of the sheet before the cell but have been unsuccessful so far.
2. For the target cell: The text coming up in this cell is created by a formula, and I cannot seem to get the change event to happen if the cell is referenced, only if I directly type in the condition.

I would like the pictures to show up based on the results in Sheet1 cell H6. The cell is dependent on an x being placed in either E6 or F6 or both to get None Left Right Or Both

[davesexcel]

Ah..
The worksheet_change event has to be in the actual sheet's module you are changing.
Right click the sheet1 tab and select "View Code", place this code there.

Please Login or Register  to view this content.

[kgall89]

I apologize, I am not very educated on VBA. I also want to make sure I am understanding your response,

The worksheet_change event has to be in the actual sheet's module you are changing.

I cannot have the pictures show up on sheet2 if the reference cell is on sheet1?

Right click the sheet1 tab and select "View Code", place this code there.

I have placed this code in the sheet one code area but am not seeing any changes to the workbook when an X is placed in E6, F5 or both.

Thank you for your patience and help with this.

[davesexcel]

Here is your wb,
BTW it's E6 & F6

[kgall89]

Thank you so much, I am not sure what I was doing wrong before but this works exactly as I dreamed!!!

I figured out that my beforedoubleclick will not trigger the change event, is there an easy solution to set a beforedoubleclick event in the "target, range" to trigger the change event? Or maybe I am asking too much of this spreadsheet. Below is my code for both the beforedoubleclick and for the change event.

BeforeDoubleClick

Please Login or Register  to view this content.

Event change

Please Login or Register  to view this content.

Again thank you so much that was a problem I was working on for quite sometime and no other solutions worked, the change event was the perfect solution.

Kyle

[davesexcel]

You have set enableevents to false so the worksheet_change event won't kick in

[kgall89]

I see.

Thank you so much for all your help. You have been very patient and helpful!!!

[davesexcel]

Here is a cleaner version,

Please Login or Register  to view this content.

[kgall89]

Great, I appreciate this!

Im having some trouble getting a picture to show up if the reference cell has a formula in it. Is this possible? Below is the code, I have tried adding in application.enableevents, but have not had success.

Please Login or Register  to view this content.

the formula in the cell is

Please Login or Register  to view this content.

I am hoping to have the picture pop up any time that D2 is greater than 2.

[davesexcel]

If D2 is being changed by using a formula, then you would have to use the worksheet_calculate event.

worksheet_change event only kicks in when you physically change a range.

Check out worksheet events here

https://www.excelforum.com/tips-and-...et-events.html

[kgall89]

Oh wow this is perfect! I will use this and these formulas a lot! It helped my figure out the calculate event. Amazing!
Thank you!