Yes but can it all be done in one cell. For example youre using K5 as your dropdown list cell but showing images in M6. Can you use K5 as the list AND display images in K5. So after you select "Davey Jones" in the list cell K5 populates with the image?
Excel does not allow you to insert an image in a cell, and text at the same time. If you put the image in the cell, then you would no longer have the drop down. I guess I cant really think of a reason one would need to do it that way? Can you elaborate more on what you are trying to accomplish?
Hello and thank you for this quick and helpful video. I am encountering a problem. In step 3, after inserting the random picture unfortunately clicking the image doesn't allow me to write the =Change_Picture. Any ideas why's that?
I was wondering the same thing. The picture he pasted had a name to it why didnt that carry over is my first questions the second question is I am doing multiple cells for this that I have named, a template that will change based on dropdown and the only thing that shows up on the bar is the writing on the template. I watched carefully and he didnt do anything special. Even tried different options of paste and no go. Would love some guidance if you have it.
Wow!!! This was really helpful!
Not using images but this should work for a template range I have named. Will see if it works, great job on the video and appreciate your making it
Yes but can it all be done in one cell. For example youre using K5 as your dropdown list cell but showing images in M6. Can you use K5 as the list AND display images in K5. So after you select "Davey Jones" in the list cell K5 populates with the image?
Excel does not allow you to insert an image in a cell, and text at the same time. If you put the image in the cell, then you would no longer have the drop down. I guess I cant really think of a reason one would need to do it that way? Can you elaborate more on what you are trying to accomplish?
Hello and thank you for this quick and helpful video. I am encountering a problem. In step 3, after inserting the random picture unfortunately clicking the image doesn't allow me to write the =Change_Picture. Any ideas why's that?
I know this is late notice but Just curious, does it not allow you to type in the formula bar, or does the picture not change?
What version of excel are you on? I have heard it doesnt work on 2007@@i-alex4613
What version of excel are you on? I have heard 2007 doesnt support it
@@i-alex4613
I was wondering the same thing. The picture he pasted had a name to it why didnt that carry over is my first questions the second question is I am doing multiple cells for this that I have named, a template that will change based on dropdown and the only thing that shows up on the bar is the writing on the template. I watched carefully and he didnt do anything special. Even tried different options of paste and no go. Would love some guidance if you have it.