Pictures brainstorm!

Will S

Board Regular
Oct 29, 2013
Hello all,

I've been working on a program that will show a different picture depending on a selection from a dropdown list, it's on a sheet that may need to be copied several times and the PC this will be used on isn't great, can anyone offer any idea for this?

Stuff I've tried already:

1. Picture Link, I had a separate sheet with all the pictures on it and a tag assigned next to them. On the actual front sheet I had the drop down list linked to the table and had a linked picture with a VLOOKUP that found the picture depending on the tag. I'm not sure if it was the type of picture that I copied in, maybe there was a way to make it smaller, but 7 pictures increased the file size by 12mb and made it slower than a snail with disabilities.

2. Stacked pictures, I'm skeptical about this idea as it means having all 7 pictures on the front sheet directly so if it's copied it will become huge and slow, but anyway... The idea is to have all pictures ontop of each other and then depending on the drop down list, all but one are invisible.

3. Import, I'm not 100% on this and haven't tried it out. But similar to the first one, is it possible to have the pictures in a file outside of the sheet and the drop down list look up file locations to import.

TL;DR? Have you needed to put in lots of images (That may or may not change) in an excel sheet that is already a strain on the processor? How did you do it? What type of picture was it? What do you think of the three ideas above?

Best regards,
Will S

Will S

Board Regular
Oct 29, 2013
Has no one has ever put a picture into excel? Can anyone recommend any low file size way of showing pictures on excel?

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...