Making a dynamic image change depending on which cell is selected

[CoogansBluff]

Is it possible to create a dynamic image that would change by selecting a different cell?

I have dynamic images that change based on a value in a cell, but I want to create one that would change based on the cell that is selected regardless of the value that is in it.

For example, let's say that I've selected cell A1 and want the image to change as I hit inter and move down A2, A3, etc. There may or may not be data entered in these cells.

 

[kevin9999]

What the demonstration code does is basically this:
It is a selection change event code, it runs when the cell you're in changes;
As long as that cell is in the range B1:B9;
When this occurs, the code grabs the name of the image from the cell to the left of the active cell (.Offset(0,-1).Value)
It looks for an image with that name on the Players sheet, if it doesn't find one of that name, you get a message to that effect and the code exits
If it finds an image with that name, it (now) deletes the image on the Main sheet where it's top left cell is in row 1, and puts that named image in cell D1
I hope that answers your question

 

[CoogansBluff]

Kevin - Thank you. That gives me a better understand of what's behind it. These are good lessons for me. Thanks again!

 

[kevin9999]

You're welcome