How to display images dynamically in Excel 

Perfect, just what I was looking for, thank you so much

I would like to say thank you, it helpe a lot, God bless you.

Thank you! Works like a charm!

Thank you very much. That was really clear and easy to follow

Thank you very much for learning of many knowledge

Thank you for this tutorial. Is there any way, that you can reduce the size of the pictures in the cells without reducing the picture quality, so you are able to size up the picture again with good quality?

Beware of using this in a workbook with VBA "for" and "with" loops. It seems to slow code execution down by a factor of 11 (eleven)! Remove the linked picture object and you're back to normal speed again. You can verify by re-building the picture object and re-running. Things go back to slow as molasses and almost crashing during execution. I can't figure out exactly whats going on here, but I'd guess a bug. Took months to figure out why macros were running so slow!

great tool!, I am trying to use the same index/Match criteria for a second set of images in a different location in my workbook. The problem I have is that the image that is returned shows all the images rather than the one linked to the dropdown selection. Any ideas?

Amazing thanks !

I did the same, but when i clicked image and typed show image, i got an error that reference is not valid.. Please some one help

just use cell refence. That will make it way easier to follow

this tricks very complicated please make it more easy process. thanks this type of tricks.

You're such Super Excel teacher. Definately liked & subscribed. Thank you very much for your valuable lesson. I have tried different ways but yours is the best. Could you please kindly teach us how to look up the photo from a photo from a network shared drive? Thanks a lot

Excellent, your a natural teacher. You explain every detail very clearly. I have set out to learn Excel as best as I can and try to understand every part so I can aly it to what ever I am trying to do. A+++ keep up the great work your posting on here.

Super! Thanks

Interesting video; kinda helps me? I'm looking to have an auction item in each row with an associated picture - up to 300. Then I need to project the image when its time. Can you walk me through that? Or maybe powerpoint would be a better tool?? Thx

I hink this is not dynamic. Dynamic is to actively load a picture into a cell from a file when you DONT have the images previously inserted into excel. This method will only work for a very limited number of images.

In case it helps anyone else, the image didn't change for me until I copied and pasted the image again, AFTER creating the link. So I followed all the steps and the image didn't change. I copied and pasted the image, and the new copy of it would change with the dropdown, even while the original one still wouldn't.

When I want to change the formula which is linked to the picture (=ShowImage in the video) keeps giving me an Error notification. Can someone help me?

Nyc

There is always a grey line around these pictures. In many cases you don't want that. How to get rid of them?

Thank you so much !!!