How to display images dynamically in Excel

Рет қаралды 48,860

3 жыл бұрын

This video shows you how to display images dynamically without the need for VBA. You will learn how to use naming cells, ranges and functions. I use the Index and Match function to carry out a lookup task.
Microsoft Tips and Tricks and learning how to be more efficient and effective

Пікірлер: 33

@kennethvela2784 5 ай бұрын

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

@InITLearning 4 ай бұрын

You’re welcome

@cascodiazcarlose9250 Жыл бұрын

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

@bazaltikus Ай бұрын

Thank you! Works like a charm!

@InITLearning Ай бұрын

I’m glad I’ve helped you. Kind regards David 👍

@Jojosmith342 Жыл бұрын

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

@jessedunn3766 Жыл бұрын

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!

@Barfaki 11 ай бұрын

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

@InITLearning 4 ай бұрын

You’re very welcome

@user-yw3wl4hu7i 6 ай бұрын

Thank you very much for learning of many knowledge

@InITLearning 6 ай бұрын

You’re very welcome Kind regards David 👍

@sujitsk 2 жыл бұрын

Super! Thanks

@sewingmachinesindetail Жыл бұрын

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?

@elim.7143 2 жыл бұрын

Amazing thanks !

@InITLearning 2 жыл бұрын

Glad you like it!

@tomzistatsis9187 Жыл бұрын

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?

@piyanann2383 Жыл бұрын

Thank you so much !!!

@InITLearning Жыл бұрын

You’re welcome ☺️

@chixripak2044 22 күн бұрын

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

@InITLearning 22 күн бұрын

Personally I would use PowerPoint. Kind regards David 👍

@suhailnbd Жыл бұрын

Nyc

@tahajasden1948 6 ай бұрын

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

@maxvandersandt2635 Жыл бұрын

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?

@losbergerdeboer-designdepa7952 Жыл бұрын

got the same thing .. i can't get out of the cell only press escape and then nothing happens..

@yohannesmekonnen685 Жыл бұрын

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

@InITLearning Жыл бұрын

Thanks for your comment

@ryanbriggs7312 6 ай бұрын

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.

@InITLearning 4 ай бұрын

Thanks for the additional input. 👍

@lucienstam7890 Жыл бұрын

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

@Chonhy 10 ай бұрын

I have the same question, so +1

@lourenz3455 10 ай бұрын

change your worksheet color to white (click any cell, double tap "ctrl A" then change fill color to white) or make the cell size much bigger than image but changing cell size doesn't work on me, so thats my workaround

@roeyni Жыл бұрын

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.