Hello Everybody,
I want to be able to display a picture based on a part number in excel. I have already figured out how to do it using a drop down list of part numbers for one picture at a time.
I want to be able to display several pictures.
I have a list of part numbers vertically and want to show the corresponding pictures next to each cell to the right of the part number.
Anybody have any idea?
Thanks
Mrichard
What version of Excel are you using currently?
If things don't change they stay the same
This is the version I have:
Microsoft® Excel® for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit
Please update your forum profile with that version (your profile says Excel 2013).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
My apologies. I just updated my profile.
Mark
Thank you.
Are your images on a local drive or hosted online?
The reason i ask about them being hosted online is because in some of the newer versions of 365 (not sure exactly which) there is a new function called: IMAGE
This function allows you to display an image in a cell based on a link, if you have the function then the below should display a picture of a cheese sandwich in the cell you place the formula in:
=IMAGE("https://static.toiimg.com/thumb/60059234.cms?width=1200&height=900",,1)
So you could place your images online and use the above formula to display them.
There are other methods to do it but i quite like the new in cell image function.
My images are in my excel workbook. I have them in a picture library. I have the part number and images next to each other vertically.
So I have a spreadsheet that automatically inserts the part numbers vertically in a different spreadsheet and I want to show the image for each part number in the cell next to the part numbers vertically.
The part numbers will change based on selections made in that spreadsheet. So when a different part number is selected I want the image to show next to it.
Make sense?
It does, thats why I suggested post 7.
If the pictures could be hosted online somewhere with the filename as the part number then you could potentially use the formula in post 7.
It would also depend on whether you have access to he IMAGE function. Does the formula in post 7 display a picture or an error?
If you don't want to/ can't host the pictures online then it would be VBA you need and not a formula. This post has been osted in the formula section of this forum.
Last edited by CheeseSandwich; 07-14-2023 at 07:20 AM.
The formula did work. I can see the sandwich. Maybe I can figure out a way to host the pictures online. I don't want to use VBA.
If you can host them online, I can help you with the formula to display them if you need it.
Might be a good idea to start off with a select few images for testing, name the files as the part numbers that you say you have listed already.
Seems to work with: https://imgbb.com/
I think if you sign up you can upload albums.
Thanks for the offer, I may take you up on it.
Let me do some research and I will get back to you.
Many thanks
Mark
Maybe you can adapt the approach described here: https://exceloffthegrid.com/automati...hange-picture/
If you can, you should be able to use the pictures you have.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Ok I will check it out.
Thanks again
I will probably have time to check it out this week.
Again thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks