Excellent tutorial up to a point. I see that many comments below pointed out that a "Reference isn't Valid""message is received as soon as you type in the reference name of the picture into the cell. I found a solution: Remember to size your picture in your "data sheet such that it fits within the boundaries of the cell. On the sheet where you created the drop-down validation list, (the same page where you want to display the picture), the cell where the picture will be displayed, must ALSO be sized such that the picture you want to see, fits perfectly into the cell. You have to necessarily resize a single cell. I used the "merge & center" command to create a larger cell by combining a number of smaller cells. After the merger, the merged cell's reference is the same as the cell that was on your top left corner of your selection.
Kobus Morgan Thanks for the comment. Actually there are several issues that cause that error. Here is another post I did about that: www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
Mike, Thanks so much for posting this. It took me a while to get my head round how it works, but I have been able to create a really good ticket writing programme for my staff to use.
Hello, I'm having issues making this work. I've followed everything step-by-step but something goes wrong when I try the INDIRECT step to link the pictures. Any advice?
Thank you so much! This could be a game changer for what I'm trying to do. After lots of trial and error and several times watching the tutorial, I finally got it to work. I would like to add this to several cells, so that my selections can be chosen in one of 25 cells. I attempted to copy/paste, but it won't keep the images. Is there a way to copy/paste (or other method) this into 25 different cells (25 different drop down boxes) and it reference the same images?
Watch the video here. You will see what you need to do for multiple selections. Let me know if you need more assistance:. www.excel-bytes.com/photos-tied-to-dropdown-list-update-in-excel/
Thanks for the video Mike...great method for a dynamic drop down photo. It's a real shame you have to go via named ranged to achieve this in Excel because if you have an entire table of photos to lookup (as I do) you need a named range for every photo...not practical for the 150 lines I have in my table unfortunately. If anyone know an alternative I'd love to hear it as VBA seems the only option at present.
I'm not 100% sure of your question, but I need to name each cell that contains a picture based on the names that I have in column A, so I use the Create From Selection option from the Formulas tab of the Ribbon
Thank for the tutorial. It's working fine (after changing the size of targeted cell). But the picture returned is wrongly formated (like cutted) and I can't change it back to original form (size is the same but the picture is offsetted right and down so part of the object in the picture is missing...)
Try to adjust the size and proportion of the cell that the picture is in. You can also send a copy of your file to mrempel@excel-bytes.com and I'll see what I can do.
Thanks so much for this. I successfully created a drop down list with images! Now, I want to copy the drop down list onto several lines but the images don't come along with the additional lists. What am I missing?
@@ExcelBytes yeah i like it very much...is it possible to do differently...lets say i have 5 dropdown cell in list A. i have 150 product with pictures in list B...is that possible to select cell among 150 products written in cell (maybe by the help of macro next to picture) send it to list A????
Thanks for the tutorial! I'm getting the "Reference isn't Valid" error when I copy the image by the dropdown and name it to the name that you create for the dropdown (i.e. in your example "WinePhoto). I have the cell where the dropdown is selected prior to creating that name. And I should mention after I create that name and check the link it doesn't highlight one of the pictures like it does in your example. Any thoughts?
Thank you for posting this video and this is the exact topic I needed but I can't seem crack the code. I've followed your instructions to the letter and no change in the photo after the =INDIRECT step? I've watched your common errors video and still no idea. Any ideas on where to turn next?
Nice video I will defnte use this : BUT!! Is it possible to do it in reverse?? Having a dropdown of the pictures and than have the text set in a cell. THANKS!!
That's what i thought.. So i now made a new sheet with all the pictures and put a macro for each picture, so when i click on one it will fill a cell with info which i then can copy.. Problem solved but i rather have them in a droplist.. I know i have seen is somewhere.. any way: thanks for the vid and the reply!!
Is there anyway to do this on a Excel for Mac 2011 version 14? It doesn't seem as though naming the photos sticks. I want to provide an image to my worksheet off of drop down list selection. thanks
This tutorial was exactly what I was looking for. I have one question. What happens if you want to scale this. For example I have a sheet called "templates" that has all the image references and the first sheet I'd like each column to have a dropdown that selects the appropriate template image - however the INDIRECT function is hard-coded to an exact cell number. Is there any for INDIRECT to use a cell that's relative? Thank you!
This works great for one word text string. I have not been able to get it to work using a text string with multiple characters. I defined the format as "text," provided a long name using _ as spaces, the indirect function turns unresponsive. Darn...this is a great tool except for long text strings!
Hi i have a issue here when i check if my selection is good after creating the INDIRECT formula, they only show me the case with the dropdown list not the picture. Btw great video
Thanks. There are actually several in this series. You can find them on UA-cam, or at my website here: www.excel-bytes.com/category/photos-from-a-drop-down-list/
I am not familiar with WPS Office. Are you using the full purchased version, which says it's 100% compatible with MS Excel, or the free version? What issues are you having with the process? There are a few different reasons why you may be having an issue that are not related to WPS Office. Can you provide more detail or send me a copy of your file and I will take a look at it? Send to mrempel@excel-bytes.com
Sorry that this is a dumb question, but do i place the picture in the cells or over the cells? Because I placed them in the cells but when i tried to copy it to the main page, i couldn’t click on the picture but only the cell.
Hey Mike--I've referenced/used your video for years but it's been a while since I've done this...and referenced it again...but this time it's not working. The images lock up or the copy/pasted photo returns "the formula results in an error or unsupported type." Do you know of anything in MO 365 that would prevent this process from a successful execution or perhaps know of a workaround?
Hello - your content is great, so helpful. My one question is if I have just one cell in a larger sheet of data, how do I work this function in seeing as it uses 2 cells? One for the drop-down and one for the result. I want to have one entry on my sheet that contains the photo.
Faith, let me see if I understand. How the process works is that there is a drop down list (or you could actually type something into the cell if it is done accurately) and based on that entry an image will appear somewhere on the worksheet, wherever you want it to. Are you saying that you want the image to appear in the same location as the entry of the choice? If that's the case, how do you then change the choice if the image is at that same location? If I'm not understand you correctly, can you send me an example file of what you are looking to do? Send it to mrempel@excel-bytes.com if you want.
Here's something I discovered that may help: 1) When you highlight everything and use "Create from Selection" to cause column B to take on column A's cell names Excel will autocheck "Top Row" and "Left Column." Then when you click "OK" Excel will ask if you want to replace the top row item in A with B...say NO. This cause cells A1 and B1 to keep their own unique characteristics, but the column items in B to adopt the names from their partner in column A. 2) In the last step where you copy/paste the picture next to the drop-down menu (that has already been made INDIRECT), you need to go back to the original image you copied and unhighlight it. Then, return to your pasted image and rename it the same name as the new INDIRECT that you created. Having the original image highlighted prevents naming the pasted image properly and you get an error message.
Hi Mike, Great video. I have a question I am trying to to create multiple drop down lists using the same reference. Will I have to keep creating a separate indirect formula for each drop down cell or is there an easier way. I tried copying and pasting but both photos change everytime I select a new item from my dropdown.
I am not aware of a way to do multiples with just copying. Be careful when you create a workbook with too many of these in it. OFFSET is a volatile function meaning that it recalculates whenever you make any changes, so it can slow down your workbook if you have a lot of these. I did a video a while ago for a client to give him some tips on how to set up a process to do this more quickly. If you send me your e-mail address to mrempel@excel-bytes.com, I will forward that video to you and maybe it will help.
Great tutorial. It seems that one would have to make an adjustment if the picture is to populate on a separate tab. What has to be done for this to work?
After you copy the photo, you can paste it in any worksheet of your workbook. Once you paste it, then go to the formula bar and enter your name manager reference (in my video that's =WinePhoto. That is the location that the image will appear when you change the selection in your drop down list.
Hi. Thanks for the tutorial! I have my data on the same sheet and would like to hide the rows that the data is in but when I do this the images disappear. Do you know how I can stop this? I have tried going into properties and selecting "don't move and size with cells" but this doesn't change anything, the pictures still disappear. Do you know how I can solve this?
Hello Michael .. I'm Running into the following problem: I Want to use multiple rows with sometimes the same photo in it.. When I simply copy and paste, then all rows get the same name and picture ...
Hi Michael, I follow the video step for step and my result is that it returns a blank image (square) when i change my selection. My pictures are clearly inside the cells as well, i have made sure of that.
Jason Caverly I'm not sure I understand the question. The point is to create a drop down list of a number of names of photos and then select one to produce that photo. What are you trying to copy down? If you want to send a sample file to show the example, you can send it to mrempel@excel-bytes.com. Thanks.
This is very close to what I am looking to do so I'm hoping you can help. I am trying to make a location finder for people in my building. The tricky part is that the building has 3 floors. Basically, I want to select a person's name from a drop down list, produce a scatter plot with their X/Y data, and format the plot area fill with a picture of their floor...or something like that. Any suggestions?
For the image of the floor, I would figure you would need a table with the employees names and the floor associated with that person. Then using VLOOKUP, by choosing the person, it would return the floor, and that cell would be used to select the proper floor image. I'd be happy to help with more details if you want to send a copy of your file to me at mrempel@excel-bytes.com with some details of what you want to accomplish.
This was great. It worked perfectly. I do have a question, can this be done with multiple images. Lets say you want to make a selection and have not just one photo but four photos appear, is that possible?
I need a bit more information to be able to answer your question. What version of Excel are you using? Is it always four images that will be pulled based on the selection? Will they appear vertically or horizontally? How many of these will there be on your worksheet? Depending on the selection, might it choose some of the same images as another selection might choose? Seeing an example of your file and requirements would be helpful. If you like, we can continue this via e-mail at mrempel@excel-bytes.com.
@@ExcelBytes I can definitely email. I’m using Office Pro Plus 2016. So I followed your method in the video, but instead of the drop down referencing one image, I would like it to reference 4 additional images (5) total. The main image on my “front” tab/page and the other four on the “back” tab/page. An example of this using your video would be selecting wine and the wine photo appears on page 1, but on page 2, four different pictures related to steps 1-4 of pouring wine correctly would appear. And this would be different for each selection. I have my data tab setup similar to your tutorial with 4 additional columns to the right of the “wine photo” images. Your thoughts?
@@2KGrafix I've created a method to do this. If you want to e-mail me with your address I can send you a file showing how you can accomplish this. Send to mrempel@excel-bytes.com.
There could be a few reasons. Your image is not completely within the cell boundaries, you have named your cell incorrectly (does it have a space?), etc. If you want to send it to me I'll take a look at it. Send to mrempel@excel-bytes.com
I am not familiar with a way to copy this process from cell to cell. There are steps you can take to make it more of an assembly line process if you have a lot of them.
Hi! Thanks for the tutorial! I'm using Excel for Mac, and it works great until the very last step, where I click on my dropdown the image doesn't change. However, the validation step you make reference to on 4:42 works well and it highlights the right cell. Any thoughts?
I'm not familiar with Mac version of Excel, but check out this video and see if it helps. if not let me know. www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
Dear Mr. Michael Rempel, I have a question. If any one wants to create another drop down cell named as glasses below heart, which you made in this video, is it possible using same cell names?
Hi, i tried several times this tutorial in Excel 2010 but it didn't work for me, first issue is in time 4:46 when Excel doesn't mark area with picture and second problem is when i try assign link '=WhinePhoto" to picture, it says 'Link is not valid' Edit: All problems solved, don't know how but on 5th attemt it works, maybe because i used underscore in link name. Thanks for great videotut. it helped me a lot,i solved this using VBA macros and it was complicated.
Thanks for your efforts.so menu bar like file, home, view etc,so If I open any menu bar then it will open more. I wanna know how to create in a Excel VBA. please try to help me Thanks again
Hi Mike, I'm having issues with the indirect function. The names for my image cells reference my "Wine" list correctly, however, when my I enter the indirect function into my dropdown, I get no response to the image cells. You gave a way to verify that the drop down is references the correct image cells, and this too doesn't give me a response. There's not spaces in any of my names. Any suggestions?
It could be a few different things. First, before you try to assign the name formula to the image, make sure you have selected an option from your drop down list. If that doesn't solve it, feel free to send me a copy of your file and I'll be happy to see what the issue is. Send to mrempel@excel-bytes.com
I'm really having a hard time with the Reference Isn't Valid. I've tried now for 3 days going back and forth with your trouble shooting and i'm getting nowhere. I know its been a long time since you created this video tutorial, but I was wondering if I was able to send you what I have made and see if you can have a look and see what i'm doing wrong?
Thank you So much Michale Rempel for you tutorial. if you have enough time can you please make a video on this topic " How to tie A PDF file to a drop-down selection in excel" thank you :-)
Instead of having it pop up, why not hyperlink to the document. Could something like this help: www.excel-bytes.com/how-to-use-hyperlinks-with-data-validation-in-excel/
With the help of your video, I made it last week. Now, I'm having the same problem. I can't put formula on the picture. Sometimes, the error is "reference isn't valid". Please help. I've tried many times.
See if this helps: ua-cam.com/video/3U38vHdfSeY/v-deo.html If not, feel free to send me a copy of your workbook and I'll figure out what the problem is.
Do you want to use Google Sheets because you are stuck on figuring out named ranges in Excel, or is that the tool you need to use? I'm not all that familiar with Google Sheets, but I took a look at it and I can not see how to name a formula using that tool. Is there some way I can help you with your Excel issue? Feel free to send me a copy of your workbook and I can see how to fix it. Send it to mrempel@excel-bytes.com
Hi Michael, I done correctly till the last step and it was fine but unable to asign the name to picture (step discribed at 5.18 on the time scale of above video) if I select the picture its not allowing me to type anything in the "formula Bar" Will you please help me on this .
+Pravin Patil There are a couple possibilities. One is that you don't have anything selected from your drop down list. Something has to be selected in order for you to be able to enter the formula in the formula bar. The other is that you don't have the names in the drop down list exactly the same as the names of the cells with the photos. Often people use spaces in the drop down list, but underscores when they name the cells. Check both these out. If it still does not work. send me the file at mrempel@excel-bytes.com and I will look at it.
check out one of these two videos: www.excel-bytes.com/how-to-tie-photos-to-a-dropdown-list-using-excel-2007/ or www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/ If neither of these help, send me a copy of your file to mrempel@excel-bytes.com and I will take a look at it.
It is coming up as reference isn't valid when I = the name of the function to the image. The pictures are being selected when testing to see if the cells are referencing correctly though
I've had this comment several times before and unfortunately there is no one reason for this. It could be a few different things. If you want to send a copy of your file to me I'll be happy to take a look at it. Send to mrempel@excel-bytes.com
You need to be more specific than "didn't work". Here is a tutorial I did about two common issues with this process. If that doesn't solve your problem, please feel free to send your file to mrempel@excel-bytes.com and I'll see what you did. www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
Followed everything exactly the same way but when I type "INDIRECT" and the cell there onwards it doesnt give me the cell selection which shows it didnt work.
Thank you for the video - very helpful!! I am 95% there but having an issue when I get to naming my picture it says my reference is invalid. Same issue as a below comment. Any suggestions??
I know this is a long time gone, but I thought if someone else was having this problem it might be helpful. If it is invalid you might have a space or a special character in your name. If the name doesn't match exactly what is in your Name Manager it will come back as invalid.
@@ngove20 are you using a capital letter in one and not the other? I would suggest going into your name manager by pressing Ctrl+from and see what naming construct there application is assigning to your name, that is how I found that my cell said "Flashlight Options" but my naming construct was "Flashlight_Options" that is what was causing my error. I hope this helps!
Thank you for your reply@@jesslo2. I have tried all lowercase and single word names. Still no dice. In the video when he defines the name with the INDIRECT formula and notices that this highlights a cell in the catalog. That how he knows it is working. That is not happening for me. I select the dropdown cell, click "define name" call it "inventory" and add the formula =INDIRECT(Catalog!$C$2). This is when I do'nt experience the highlighting of the catalog cell.
Jessica Ohler is there a way to do it with a space as I would like to use this with names (forename surname) but when I do I get an error. Many thanks Gary
Hello Michael, Please can you help me? I have used your video several times and not had an issue with tying down 1-4 pictures, but now I am trying to tie down 8 photos, the first 3 work but the rest are copies from photo 3??? I am using 2010. Best Regards Bev
I am having one issue. the pictures change along with my selections, however, it is blowing the picture up and only showing a blurry corner of the picture. how do I fix this?
when I highlight both the right and left column to have the photos reference the name, as soon as I click ok, it asks if I want to replace existing definition?? am I missing something? The photos are in the cell and not over the cell.
@@ExcelBytes Unfortunately, following the process, and all the photos fit in the perimeter of the cell, either no photos show up, or the entire list of photos show up in the cell. I am using excel 2016 latest version. Definitely a work in progress on my end. 🤔
What if I have a large list of rows which includes a column "country" and I want to display a flag in every row? Do I need to create a 190+ named ranges?
Here is a link to a video you can download that might help you. I made this for someone else that had a lot of these to create. This process was never designed to easily handle hundreds of scenarios.: app.box.com/s/10cl2vqmb2ald1rnpb7fv1sxq9dzcixx
hi michael iwatch this video and succesfull made my dropdown in a excel file now my question is it posible and how to make data sheet with multiple rows in the data list my pict are dif wide and small one in big cell give not the result
+atelier schmit I'd love to help but am not sure I understand your requirements. Can you send me a sample file with more detail and I'll see that I can do. Send it to mrempel@excel-bytes.com
Function worked great, but for some reason it added a 1px gray box around my image and I need it clean (it's a transparent bg .png). Anyone know a quickfix? Thanks.
@@ExcelBytes thanks, but I was able to get it fixed. All I had to do was turn gridlines off on the sheet my images were on and the gray border (which was actually literally the gridlines from the sheet, who knew?) were gone! Not only is it literally showing you the image as contained within the cell exactly as is, but it's displaying literally the entire cell itself to include invisible gridlines (which were for some reason printing, but not set to on the source sheet the images were on).
My pictures are different sizes, when I select a new option it scales the new picture to fit in the same size space that the previous one was in. How can I keep all photos at 100% ratio and avoid scaling?
+mohamed dyab I think you sent me your file and I have replied to it via e-mail. Basically, you have to have something selected from your drop down list before you type the name of the INDIRECT function into the formula bar.
hi, i have done everything but in the image, i see many rows and columns including the pics that i inserted in the cells, all in one image. why is it like that?
Umar Aftab i tried the trick on a new sheet , it worked, but not in the sheet i have been working all day. pls help me , i dont know what is wrong with it
This is really not designed for multiple cells. Here is an update I did and toward the end I show how you need to modify it for multiple cells ua-cam.com/video/aZLSt42N9Kc/v-deo.html
Hmm...I get to where I am naming my picture by clicking on the new name in the drop down menu (for example =Picture) but it says my reference is invalid. Any ideas?
Everything works great until I get to the indirect step. It does not click back to the photo on the data page. Everything up until that works perfectly. I don't know if it is because excel may have updates since original video. But this is EXACTLY what I need this to do. (I'd rather google sheets, but, hey, this would work just fine!)
I downloaded the sample you created and uploaded it to google sheet. Everything worked BUT the images switching according to the list item. Must not be supported im guessing.
Thank you for trying, I appreciate it. I did find some indirect functions tutorials for google sheets, but like you said.. dont know if you can use it for images
Dustin Sayre I was able to create this procedure on 2013 an 2010, but I see what you mean regarding 2007. Let me hob-nob with my fellow wizards and see if I can come up with a work-around.
Dustin Sayre Here is a video on how this must be done in 2007. I've been able to replicate this process and it works well. ua-cam.com/video/W_GBoDkb2pI/v-deo.html Let me know if you have any problems with it. If you do, send me the file at mrempel@excel-bytes.com and I will look at it.
Nice one Excel Bytes for video, and for answering feedback; great stuff, sir. Works a treat, had some fun and it took me several hours as using 2007 version of Excel. Perseverance with Excel, as always, is the key :)
Could be a couple reasons. Do you have something selected on your drop down list when you copy the photo, paste it and reference the named formula? Also, check this out to see if either of these issues is the problem: www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/. If these don't help, you can send me your file and I will look at it. Send to mrempel@excel-bytes.com
When I use the name manager and inderect, it doesn't highlight my picture on the other sheet. Then when I try to rename the picture, I get a reference invalid error. Any ideas?
There could be a couple things. Check out this blog post - two most common error when trying this process: goo.gl/Aaow2X. Also, if you go here: goo.gl/D9ywYT you'll find 7 different blog posts about this topic. Finally, if nothing works for you, feel free to send a copy of the file to mrempel@excel-bytes.com and I'll be happy to look at it. BTW, often the reference invalid error is due to the fact that you have nothing selected in your drop down list.
After entering the indirect formula in the name manager, it does not highlight one of the pictures on the other sheet, even though I have a selection made prior to this step.
thanks, btw just realized that if you have names with spaces or special characters it does not work. Names should be simple like in your example (can't be red apple but redapple)
I do not know if it is my laptop or your video but I did not hear any sound associated with your video. If your video is only a audio then I'd strongly advise implementing some verbal explanation because a video only is very useless in my opinion.
what you made is not called Tie Photos to a Dropdown List ,,,,,is bind images to a list and thas all........what people think is that you actually created a Dropdownlist made by images wich is not in this case.
Awesome video - quick and to the point.
Thanks!
Wow. I was able to create an invoice template with the pictures of the items as I am choosing the items. Thanks for that.
Glad you liked it and found it useful!
Excellent tutorial up to a point. I see that many comments below pointed out that a "Reference isn't Valid""message is received as soon as you type in the reference name of the picture into the cell. I found a solution:
Remember to size your picture in your "data sheet such that it fits within the boundaries of the cell. On the sheet where you created the drop-down validation list, (the same page where you want to display the picture), the cell where the picture will be displayed, must ALSO be sized such that the picture you want to see, fits perfectly into the cell. You have to necessarily resize a single cell. I used the "merge & center" command to create a larger cell by combining a number of smaller cells.
After the merger, the merged cell's reference is the same as the cell that was on your top left corner of your selection.
Kobus Morgan Thanks for the comment. Actually there are several issues that cause that error. Here is another post I did about that: www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
@@ExcelBytes Your fix for Reference isn't valid doesn't seem to work.
Thank you for the video, this is what I was looking for, and it is easy to use.
Thank you show much for show me the way. Wishes you all the best! ♥
Thanks!
Exactly what I needed! Thanks a bunch! 😃
Great, glad you found it useful!
Mike, Thanks so much for posting this. It took me a while to get my head round how it works, but I have been able to create a really good ticket writing programme for my staff to use.
Glad to hear you got it to work! Let me know if you have any questions on it.
Great tutorial and really helpful, thank you.
Thanks!
Hello, I'm having issues making this work. I've followed everything step-by-step but something goes wrong when I try the INDIRECT step to link the pictures. Any advice?
Thank you so much! This could be a game changer for what I'm trying to do. After lots of trial and error and several times watching the tutorial, I finally got it to work. I would like to add this to several cells, so that my selections can be chosen in one of 25 cells. I attempted to copy/paste, but it won't keep the images. Is there a way to copy/paste (or other method) this into 25 different cells (25 different drop down boxes) and it reference the same images?
Watch the video here. You will see what you need to do for multiple selections. Let me know if you need more assistance:. www.excel-bytes.com/photos-tied-to-dropdown-list-update-in-excel/
@@ExcelBytes This takes me to the website with a downloadable sheet, but no video to watch to see your steps.
@@csmithwoodworking keep scrolling down
Thank you, excellent tutorial!
Glad you liked it! Hope you find it useful.
Thanks for the video Mike...great method for a dynamic drop down photo. It's a real shame you have to go via named ranged to achieve this in Excel because if you have an entire table of photos to lookup (as I do) you need a named range for every photo...not practical for the 150 lines I have in my table unfortunately. If anyone know an alternative I'd love to hear it as VBA seems the only option at present.
YOU ARE A LIFE SAVER!!! THANK YOU SO MUCH
Great, glad you found it useful!
Thank you very much !!
I'm glad you liked it.
2:50, when you say name each cell. Are you using the define cell and making the scope only that sheet or the workbook?
I'm not 100% sure of your question, but I need to name each cell that contains a picture based on the names that I have in column A, so I use the Create From Selection option from the Formulas tab of the Ribbon
Thank for the tutorial. It's working fine (after changing the size of targeted cell). But the picture returned is wrongly formated (like cutted) and I can't change it back to original form (size is the same but the picture is offsetted right and down so part of the object in the picture is missing...)
Try to adjust the size and proportion of the cell that the picture is in. You can also send a copy of your file to mrempel@excel-bytes.com and I'll see what I can do.
Thanks so much for this. I successfully created a drop down list with images! Now, I want to copy the drop down list onto several lines but the images don't come along with the additional lists. What am I missing?
Looks like you have to do the same thing over again, lots have asked this
wow, excellent sir
Thanks, glad you liked it!
@@ExcelBytes yeah i like it very much...is it possible to do differently...lets say i have 5 dropdown cell in list A. i have 150 product with pictures in list B...is that possible to select cell among 150 products written in cell (maybe by the help of macro next to picture) send it to list A????
Thanks for the tutorial! I'm getting the "Reference isn't Valid" error when I copy the image by the dropdown and name it to the name that you create for the dropdown (i.e. in your example "WinePhoto). I have the cell where the dropdown is selected prior to creating that name. And I should mention after I create that name and check the link it doesn't highlight one of the pictures like it does in your example. Any thoughts?
Colin Lammers see if this helps. www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
Thank you for posting this video and this is the exact topic I needed but I can't seem crack the code. I've followed your instructions to the letter and no change in the photo after the =INDIRECT step? I've watched your common errors video and still no idea. Any ideas on where to turn next?
Josh L send me your file to mrempel@excel-bytes.com and I'll take a look at it.
Nice video I will defnte use this : BUT!! Is it possible to do it in reverse?? Having a dropdown of the pictures and than have the text set in a cell. THANKS!!
I don't know how you can do that since the pictures are actually floating objects and don't really have a specific cell location.
That's what i thought.. So i now made a new sheet with all the pictures and put a macro for each picture, so when i click on one it will fill a cell with info which i then can copy.. Problem solved but i rather have them in a droplist.. I know i have seen is somewhere.. any way: thanks for the vid and the reply!!
Is there anyway to do this on a Excel for Mac 2011 version 14?
It doesn't seem as though naming the photos sticks. I want to provide an image to my worksheet off of drop down list selection.
thanks
This tutorial was exactly what I was looking for. I have one question. What happens if you want to scale this.
For example I have a sheet called "templates" that has all the image references and the first sheet I'd like each column to have a dropdown that selects the appropriate template image - however the INDIRECT function is hard-coded to an exact cell number. Is there any for INDIRECT to use a cell that's relative?
Thank you!
This works great for one word text string. I have not been able to get it to work using a text string with multiple characters. I defined the format as "text," provided a long name using _ as spaces, the indirect function turns unresponsive. Darn...this is a great tool except for long text strings!
We can make it work. Can you send me a copy of your workbook with an explanation of what you want? Send to mrempel@excel-bytes.com
Hi i have a issue here when i check if my selection is good after creating the INDIRECT formula, they only show me the case with the dropdown list not the picture.
Btw great video
Thanks for the tutorial
Thanks. There are actually several in this series. You can find them on UA-cam, or at my website here: www.excel-bytes.com/category/photos-from-a-drop-down-list/
May I know if this also works in WPS Office Excel? I have difficult in typing at the formula bar when the image is selected. Thank you!
I am not familiar with WPS Office. Are you using the full purchased version, which says it's 100% compatible with MS Excel, or the free version? What issues are you having with the process? There are a few different reasons why you may be having an issue that are not related to WPS Office. Can you provide more detail or send me a copy of your file and I will take a look at it? Send to mrempel@excel-bytes.com
Sorry that this is a dumb question, but do i place the picture in the cells or over the cells? Because I placed them in the cells but when i tried to copy it to the main page, i couldn’t click on the picture but only the cell.
Over the cell
Hey Mike--I've referenced/used your video for years but it's been a while since I've done this...and referenced it again...but this time it's not working. The images lock up or the copy/pasted photo returns "the formula results in an error or unsupported type." Do you know of anything in MO 365 that would prevent this process from a successful execution or perhaps know of a workaround?
Not sure. Are you able to send me a copy of your file to look at?
Hello - your content is great, so helpful. My one question is if I have just one cell in a larger sheet of data, how do I work this function in seeing as it uses 2 cells? One for the drop-down and one for the result. I want to have one entry on my sheet that contains the photo.
Faith, let me see if I understand. How the process works is that there is a drop down list (or you could actually type something into the cell if it is done accurately) and based on that entry an image will appear somewhere on the worksheet, wherever you want it to. Are you saying that you want the image to appear in the same location as the entry of the choice? If that's the case, how do you then change the choice if the image is at that same location? If I'm not understand you correctly, can you send me an example file of what you are looking to do? Send it to mrempel@excel-bytes.com if you want.
Here's something I discovered that may help: 1) When you highlight everything and use "Create from Selection" to cause column B to take on column A's cell names Excel will autocheck "Top Row" and "Left Column." Then when you click "OK" Excel will ask if you want to replace the top row item in A with B...say NO. This cause cells A1 and B1 to keep their own unique characteristics, but the column items in B to adopt the names from their partner in column A. 2) In the last step where you copy/paste the picture next to the drop-down menu (that has already been made INDIRECT), you need to go back to the original image you copied and unhighlight it. Then, return to your pasted image and rename it the same name as the new INDIRECT that you created. Having the original image highlighted prevents naming the pasted image properly and you get an error message.
Thank you so much! It works now for me!
Hi Mike,
Great video. I have a question I am trying to to create multiple drop down lists using the same reference. Will I have to keep creating a separate indirect formula for each drop down cell or is there an easier way. I tried copying and pasting but both photos change everytime I select a new item from my dropdown.
I am not aware of a way to do multiples with just copying. Be careful when you create a workbook with too many of these in it. OFFSET is a volatile function meaning that it recalculates whenever you make any changes, so it can slow down your workbook if you have a lot of these. I did a video a while ago for a client to give him some tips on how to set up a process to do this more quickly. If you send me your e-mail address to mrempel@excel-bytes.com, I will forward that video to you and maybe it will help.
Thank you for this Tutorial ___If it is possible I want this Tuto on PDF step by step
+احمد ادريس Thanks! Glad you liked it!
Great tutorial. It seems that one would have to make an adjustment if the picture is to populate on a separate tab. What has to be done for this to work?
After you copy the photo, you can paste it in any worksheet of your workbook. Once you paste it, then go to the formula bar and enter your name manager reference (in my video that's =WinePhoto. That is the location that the image will appear when you change the selection in your drop down list.
Hi. Thanks for the tutorial! I have my data on the same sheet and would like to hide the rows that the data is in but when I do this the images disappear. Do you know how I can stop this? I have tried going into properties and selecting "don't move and size with cells" but this doesn't change anything, the pictures still disappear. Do you know how I can solve this?
Hello Michael ..
I'm Running into the following problem:
I Want to use multiple rows with sometimes the same photo in it..
When I simply copy and paste, then all rows get the same name and picture ...
Hi Michael, I follow the video step for step and my result is that it returns a blank image (square) when i change my selection. My pictures are clearly inside the cells as well, i have made sure of that.
Thanks for the video, I got it to work, my only question is can you copy this down a cell or do you have to do it all over again for each cell?
Jason Caverly I'm not sure I understand the question. The point is to create a drop down list of a number of names of photos and then select one to produce that photo. What are you trying to copy down? If you want to send a sample file to show the example, you can send it to mrempel@excel-bytes.com. Thanks.
I know what u mean..... Could u do it?
This is very close to what I am looking to do so I'm hoping you can help. I am trying to make a location finder for people in my building. The tricky part is that the building has 3 floors. Basically, I want to select a person's name from a drop down list, produce a scatter plot with their X/Y data, and format the plot area fill with a picture of their floor...or something like that. Any suggestions?
For the image of the floor, I would figure you would need a table with the employees names and the floor associated with that person. Then using VLOOKUP, by choosing the person, it would return the floor, and that cell would be used to select the proper floor image. I'd be happy to help with more details if you want to send a copy of your file to me at mrempel@excel-bytes.com with some details of what you want to accomplish.
This was great. It worked perfectly. I do have a question, can this be done with multiple images. Lets say you want to make a selection and have not just one photo but four photos appear, is that possible?
I need a bit more information to be able to answer your question. What version of Excel are you using? Is it always four images that will be pulled based on the selection? Will they appear vertically or horizontally? How many of these will there be on your worksheet? Depending on the selection, might it choose some of the same images as another selection might choose? Seeing an example of your file and requirements would be helpful. If you like, we can continue this via e-mail at mrempel@excel-bytes.com.
@@ExcelBytes I can definitely email. I’m using Office Pro Plus 2016. So I followed your method in the video, but instead of the drop down referencing one image, I would like it to reference 4 additional images (5) total. The main image on my “front” tab/page and the other four on the “back” tab/page. An example of this using your video would be selecting wine and the wine photo appears on page 1, but on page 2, four different pictures related to steps 1-4 of pouring wine correctly would appear. And this would be different for each selection. I have my data tab setup similar to your tutorial with 4 additional columns to the right of the “wine photo” images. Your thoughts?
@@ExcelBytes And again, thank you for all your help, i will definitely drop some $ in your paypal.
@@2KGrafix I've created a method to do this. If you want to e-mail me with your address I can send you a file showing how you can accomplish this. Send to mrempel@excel-bytes.com.
Very nice sir ji
Thank you! Glad you liked it!
It works perfectly but only for 2 items from my drop down menu instead of all 5. I am getting crazy. Any suggestions?
There could be a few reasons. Your image is not completely within the cell boundaries, you have named your cell incorrectly (does it have a space?), etc. If you want to send it to me I'll take a look at it. Send to mrempel@excel-bytes.com
Hi there! Is there a way to write a formula so I could copy it to different cells and show different pictures?
Thanks!
I am not familiar with a way to copy this process from cell to cell. There are steps you can take to make it more of an assembly line process if you have a lot of them.
Hi! Thanks for the tutorial! I'm using Excel for Mac, and it works great until the very last step, where I click on my dropdown the image doesn't change. However, the validation step you make reference to on 4:42 works well and it highlights the right cell.
Any thoughts?
I'm not familiar with Mac version of Excel, but check out this video and see if it helps. if not let me know.
www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
Thank you! Downloading the file really worked. No differences in this case between Mac and Windows.
Does this work in Excel 2003? Getting an error that name list must be in active sheet
Dear Mr. Michael Rempel, I have a question.
If any one wants to create another drop down cell named as glasses below heart, which you made in this video, is it possible using same cell names?
***** for more clarity, i have mailed an excel sheet.
Hi, i tried several times this tutorial in Excel 2010 but it didn't work for me, first issue is in time 4:46 when Excel doesn't mark area with picture and second problem is when i try assign link '=WhinePhoto" to picture, it says 'Link is not valid'
Edit: All problems solved, don't know how but on 5th attemt it works, maybe because i used underscore in link name. Thanks for great videotut. it helped me a lot,i solved this using VBA macros and it was complicated.
Thanks for your efforts.so menu bar like file, home, view etc,so If I open any menu bar then it will open more. I wanna know how to create in a Excel VBA. please try to help me
Thanks again
Check out Wise Owl VBA tutorials on UA-cam. He does a great job and has a whole lot of videos where you can learn all about VBA.
Hi Mike,
I'm having issues with the indirect function. The names for my image cells reference my "Wine" list correctly, however, when my I enter the indirect function into my dropdown, I get no response to the image cells. You gave a way to verify that the drop down is references the correct image cells, and this too doesn't give me a response. There's not spaces in any of my names. Any suggestions?
Not sure, but I'd be happy to take a look at your file if you want to send it to mrempel@excel-bytes.com
HI Mike,
I get a error Reference isn't valid when I try to assign the Name formula to the image.
How to resolve it?
It could be a few different things. First, before you try to assign the name formula to the image, make sure you have selected an option from your drop down list. If that doesn't solve it, feel free to send me a copy of your file and I'll be happy to see what the issue is. Send to mrempel@excel-bytes.com
Very nice video. Nice person. Nice nice.
Thanks!
Is there a way to use this for excel online because this only works offline?
Unfortunately, I was unable to use this file onfline. Excel indicated that several features are not supported in the online version. Sorry.
I'm really having a hard time with the Reference Isn't Valid. I've tried now for 3 days going back and forth with your trouble shooting and i'm getting nowhere. I know its been a long time since you created this video tutorial, but I was wondering if I was able to send you what I have made and see if you can have a look and see what i'm doing wrong?
Sure, I'd be happy to look at it. Send it to mrempel@excel-bytes.com
Thank you So much Michale Rempel for you tutorial. if you have enough time can you please make a video on this topic " How to tie A PDF file to a drop-down selection in excel"
thank you :-)
Instead of having it pop up, why not hyperlink to the document. Could something like this help:
www.excel-bytes.com/how-to-use-hyperlinks-with-data-validation-in-excel/
Thank you so much. ♥
You're welcome, glad you liked it.
Please let me know about the menu bar and submenubar in Excel VBA
Thanks
Can you be more specific about what you want to know? I am not a VBA expert, so going to one that can provide more expertise may be wise.
With the help of your video, I made it last week. Now, I'm having the same problem. I can't put formula on the picture. Sometimes, the error is "reference isn't valid". Please help. I've tried many times.
See if this helps: ua-cam.com/video/3U38vHdfSeY/v-deo.html If not, feel free to send me a copy of your workbook and I'll figure out what the problem is.
What if i have6 drop down list and i need to show photos of 6. 1 from each drop down list. Is this possible???
Yes, you will have to create 6 different named formulas like WinePhoto1, WinePhoto2, etc.
Nice tutorial ^^) I have the problem that i can't insert a formula is my pasted picture, can you help?
***** found it, i have excel 2007, made a bitmap and addid the formula of indirect in that
thanx
Can this been done in Google sheets? I'm stuck on the Name the range part.
Do you want to use Google Sheets because you are stuck on figuring out named ranges in Excel, or is that the tool you need to use? I'm not all that familiar with Google Sheets, but I took a look at it and I can not see how to name a formula using that tool. Is there some way I can help you with your Excel issue? Feel free to send me a copy of your workbook and I can see how to fix it. Send it to mrempel@excel-bytes.com
Hi Michael, I done correctly till the last step and it was fine but unable to asign the name to picture (step discribed at 5.18 on the time scale of above video) if I select the picture its not allowing me to type anything in the "formula Bar" Will you please help me on this .
+Pravin Patil There are a couple possibilities. One is that you don't have anything selected from your drop down list. Something has to be selected in order for you to be able to enter the formula in the formula bar. The other is that you don't have the names in the drop down list exactly the same as the names of the cells with the photos. Often people use spaces in the drop down list, but underscores when they name the cells. Check both these out. If it still does not work. send me the file at mrempel@excel-bytes.com and I will look at it.
check out one of these two videos: www.excel-bytes.com/how-to-tie-photos-to-a-dropdown-list-using-excel-2007/ or www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/ If neither of these help, send me a copy of your file to mrempel@excel-bytes.com and I will take a look at it.
It is coming up as reference isn't valid when I = the name of the function to the image. The pictures are being selected when testing to see if the cells are referencing correctly though
I've had this comment several times before and unfortunately there is no one reason for this. It could be a few different things. If you want to send a copy of your file to me I'll be happy to take a look at it. Send to mrempel@excel-bytes.com
I don't find "Create from Selection". I'm using Excel for Mac 2011
nice video sir
Thanks, glad you liked it.
Thank you, I've followed your steps strictly but the data validation and selection from left column didn't work !! I'm using MSO2016 .
You need to be more specific than "didn't work". Here is a tutorial I did about two common issues with this process. If that doesn't solve your problem, please feel free to send your file to mrempel@excel-bytes.com and I'll see what you did. www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
how did you make your grid lines appear that way ??
Can you be more specific as to what you are talking about?
I m not able to inserting the formula in the photo. Im using excel 2007
Search my site. I did a separate video for 2007.
Followed everything exactly the same way but when I type "INDIRECT" and the cell there onwards it doesnt give me the cell selection which shows it didnt work.
I'm guessing there is something slightly amiss. You can send me your file and I will take a look at it. Send to mrempel@excel-bytes.com
Thank you for the video - very helpful!! I am 95% there but having an issue when I get to naming my picture it says my reference is invalid. Same issue as a below comment. Any suggestions??
I know this is a long time gone, but I thought if someone else was having this problem it might be helpful. If it is invalid you might have a space or a special character in your name. If the name doesn't match exactly what is in your Name Manager it will come back as invalid.
@@jesslo2 I have no special characters or spaces in the name. Still coming back invalid. Any suggestions?
@@ngove20 are you using a capital letter in one and not the other? I would suggest going into your name manager by pressing Ctrl+from and see what naming construct there application is assigning to your name, that is how I found that my cell said "Flashlight Options" but my naming construct was "Flashlight_Options" that is what was causing my error. I hope this helps!
Thank you for your reply@@jesslo2. I have tried all lowercase and single word names. Still no dice. In the video when he defines the name with the INDIRECT formula and notices that this highlights a cell in the catalog. That how he knows it is working. That is not happening for me. I select the dropdown cell, click "define name" call it "inventory" and add the formula =INDIRECT(Catalog!$C$2). This is when I do'nt experience the highlighting of the catalog cell.
Jessica Ohler is there a way to do it with a space as I would like to use this with names (forename surname) but when I do I get an error. Many thanks Gary
Hello Michael, Please can you help me? I have used your video several times and not had an issue with tying down 1-4 pictures, but now I am trying to tie down 8 photos, the first 3 work but the rest are copies from photo 3??? I am using 2010. Best Regards Bev
Beverley Nash I'd be happy to help. Do you want to send me your file and I will look at it.
Send it to mrempel@excel-bytes.com
I am having one issue. the pictures change along with my selections, however, it is blowing the picture up and only showing a blurry corner of the picture. how do I fix this?
Are you willing to send me a copy of your file so I can see the issue and try to solve it? Send to mrempel@excel-bytes.com
My apologies, I had my internet muted. Sound for video works.
when I highlight both the right and left column to have the photos reference the name, as soon as I click ok, it asks if I want to replace existing definition?? am I missing something? The photos are in the cell and not over the cell.
The photos need to be objects that are over the cell and not touch any of the perimeter of the cell
@@ExcelBytes Unfortunately, following the process, and all the photos fit in the perimeter of the cell, either no photos show up, or the entire list of photos show up in the cell. I am using excel 2016 latest version. Definitely a work in progress on my end.
🤔
@@syphadeous Can you send me a copy of your file, and I'll be happy to look at it. Send to mrempel@excel-bytes.com
What if I have a large list of rows which includes a column "country" and I want to display a flag in every row? Do I need to create a 190+ named ranges?
Here is a link to a video you can download that might help you. I made this for someone else that had a lot of these to create. This process was never designed to easily handle hundreds of scenarios.: app.box.com/s/10cl2vqmb2ald1rnpb7fv1sxq9dzcixx
hi michael iwatch this video and succesfull made my dropdown in a excel file now my question is it posible and how to make data sheet with multiple rows in the data list my pict are dif wide and small one in big cell give not the result
+atelier schmit I'd love to help but am not sure I understand your requirements. Can you send me a sample file with more detail and I'll see that I can do. Send it to mrempel@excel-bytes.com
Function worked great, but for some reason it added a 1px gray box around my image and I need it clean (it's a transparent bg .png). Anyone know a quickfix? Thanks.
Can you send me a copy of your file and I'll see what is going on? Send to mrempel@excel-bytes.com
@@ExcelBytes thanks, but I was able to get it fixed. All I had to do was turn gridlines off on the sheet my images were on and the gray border (which was actually literally the gridlines from the sheet, who knew?) were gone! Not only is it literally showing you the image as contained within the cell exactly as is, but it's displaying literally the entire cell itself to include invisible gridlines (which were for some reason printing, but not set to on the source sheet the images were on).
My pictures are different sizes, when I select a new option it scales the new picture to fit in the same size space that the previous one was in. How can I keep all photos at 100% ratio and avoid scaling?
It shouldn't. Can you send me a copy of your file and let me look at it. Maybe I can see something in the photo properties that is causing this
@@ExcelBytes I have emailed you a copy, looking forward to hearing back from you soon.
Im having a problem in inserting the formula in the photo. Im using excel 2007
check out this video to see if it helps. www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
please help me its not working with me i do every thing until the end but at the end when i came to the photo step error come (reference is not valid)
+mohamed dyab I think you sent me your file and I have replied to it via e-mail. Basically, you have to have something selected from your drop down list before you type the name of the INDIRECT function into the formula bar.
hi, i have done everything but in the image, i see many rows and columns including the pics that i inserted in the cells, all in one image. why is it like that?
its Showing 38 colums and 5 rows in the final image, while i tested this trick for 2 itemswhat is it that im doing wrong
Umar Aftab i tried the trick on a new sheet , it worked, but not in the sheet i have been working all day. pls help me , i dont know what is wrong with it
how do i do that for several cells at once. nothing is working
This is really not designed for multiple cells. Here is an update I did and toward the end I show how you need to modify it for multiple cells ua-cam.com/video/aZLSt42N9Kc/v-deo.html
Hmm...I get to where I am naming my picture by clicking on the new name in the drop down menu (for example =Picture) but it says my reference is invalid.
Any ideas?
*****
Thanks Michael,
I did end up sending you a file. Thanks for your willingness to be so helpful!
Are you able to insert this drop down list with images into word?
I am not well versed in Microsoft Word, so I'm not sure if it's possible, but understanding the need to use formulas, I don't think it can be done.
@@ExcelBytes thank you for taking the time to reply.
ctl + F3 doesn't work on Mac...:(
Everything works great until I get to the indirect step. It does not click back to the photo on the data page. Everything up until that works perfectly. I don't know if it is because excel may have updates since original video. But this is EXACTLY what I need this to do. (I'd rather google sheets, but, hey, this would work just fine!)
Send me a copy of your file and I will look at it. Send to mrempel@excel-bytes.com
Where can I find this type of tutorial for google sheets?
I downloaded the sample you created and uploaded it to google sheet. Everything worked BUT the images switching according to the list item. Must not be supported im guessing.
Thank you for trying, I appreciate it. I did find some indirect functions tutorials for google sheets, but like you said.. dont know if you can use it for images
Everything works perfect, but when i try to assign the range name to the image, i can't... A window comes saying "invalid reference" Any idea?
watch this video www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
watch this video www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
I am using Excel 2007 and for some reason I am not able to name the image. Is there a trick to getting this to work?
Dustin Sayre I was able to create this procedure on 2013 an 2010, but I see what you mean regarding 2007. Let me hob-nob with my fellow wizards and see if I can come up with a work-around.
Dustin Sayre Here is a video on how this must be done in 2007. I've been able to replicate this process and it works well. ua-cam.com/video/W_GBoDkb2pI/v-deo.html Let me know if you have any problems with it. If you do, send me the file at mrempel@excel-bytes.com and I will look at it.
Nice one Excel Bytes for video, and for answering feedback; great stuff, sir. Works a treat, had some fun and it took me several hours as using 2007 version of Excel. Perseverance with Excel, as always, is the key :)
I keep getting Reference isn't valid. What am I doing wrong?
Could be a couple reasons. Do you have something selected on your drop down list when you copy the photo, paste it and reference the named formula? Also, check this out to see if either of these issues is the problem: www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/.
If these don't help, you can send me your file and I will look at it. Send to mrempel@excel-bytes.com
When I use the name manager and inderect, it doesn't highlight my picture on the other sheet. Then when I try to rename the picture, I get a reference invalid error. Any ideas?
There could be a couple things. Check out this blog post - two most common error when trying this process: goo.gl/Aaow2X. Also, if you go here: goo.gl/D9ywYT you'll find 7 different blog posts about this topic. Finally, if nothing works for you, feel free to send a copy of the file to mrempel@excel-bytes.com and I'll be happy to look at it. BTW, often the reference invalid error is due to the fact that you have nothing selected in your drop down list.
Thank you for the reply!
After entering the indirect formula in the name manager, it does not highlight one of the pictures on the other sheet, even though I have a selection made prior to this step.
Can you send me a copy of your workbook and I will look at it. Send to mrempel@excel-bytes.com
thank yous o much
Empire _Stevenson You're welcome. Glad you liked it.
BC how add picture in Excel Cell ?
Jay, can you please elaborate on your question? Are you asking how to insert a picture into a cell in Excel?
I want to make a student result particularly with picture I don't know how to use picture using vlookup
Not sure exactly what you want to accomplish - can you send me a file with an example> Send to mrempel@excel-bytes.com
what if i used combo box , can i use this method?
Yes, here is an example: app.box.com/s/ty65hv3q38a32vfj5h4titgtekxmj8af
Thanks a lot! Btw, what if I combine both the picture and a graph in one combo box, is that possible?
See this: app.box.com/s/9q1bni2ka8wzqs3qol0xtaw49wj7xgnx
can i use form controls instead of activexcontrols
Yes, that would work also
how can i add Picture inside a cell?
thanks, btw just realized that if you have names with spaces or special characters it does not work. Names should be simple like in your example (can't be red apple but redapple)
thank you very much :)
Doesn't work for me. I've spent over an hour replaying after 4:14. I guess I suck
I do not know if it is my laptop or your video but I did not hear any sound associated with your video. If your video is only a audio then I'd strongly advise implementing some verbal explanation because a video only is very useless in my opinion.
If you get reference invalid make sure the names of your pictures don't have any spaces
Exactly! I cover that in this tutorial: www.excel-bytes.com/the-two-most-common-errors-when-selecting-photos-from-a-drop-down-list-in-excel/
what you made is not called Tie Photos to a Dropdown List ,,,,,is bind images to a list and thas all........what people think is that you actually created a Dropdownlist made by images wich is not in this case.
Make it where people can download the sample.