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
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
