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.
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
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?
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?
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!
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
Did you insert the image over cells and not in cell. Just a new (ish) feature. Thought it best to check that first.Also what version of Excel are you using
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
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.
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.
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.
Thank you
Perfect, just what I was looking for, thank you so much
You’re welcome
I would like to say thank you, it helpe a lot, God bless you.
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
Thank you very much for learning of many knowledge
You’re very welcome Kind regards David 👍
Thank you very much. That was really clear and easy to follow
You’re very welcome
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?
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?
Thank you! Works like a charm!
I’m glad I’ve helped you. Kind regards David 👍
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!
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
Personally I would use PowerPoint. Kind regards David 👍
Good stuff!
Thanks
Amazing thanks !
Glad you like it!
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
Super! Thanks
Superb
Thanks 👍
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?
got the same thing .. i can't get out of the cell only press escape
and then nothing happens..
Gone through the whole video but when I click on the image it won't let me write on the formula bar.
Did you insert the image over cells and not in cell. Just a new (ish) feature. Thought it best to check that first.Also what version of Excel are you using
There is always a grey line around these pictures. In many cases you don't want that. How to get rid of them?
I have the same question, so +1
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
Thank you so much !!!
You’re welcome ☺️
Nyc
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.
Thanks for the additional input. 👍
just use cell refence. That will make it way easier to follow
Thanks for your comment
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.
this tricks very complicated please make it more easy process. thanks this type of tricks.