Picture problem

There are a few ways to accomplish what you're asking for, depending on the set-up you prefer.

Let's start with some basic questions:
Do you want to pull the pictures from a folder library or store them all in the workbook? If it's only a few pictures, the workbook method might be attractive. But if there are many, the workbook could become unnecessarily bloated with picture files.

How many pictures do you anticipate displaying per job?

That's all for now....
Meanwhile, here are a couple links that demonstate two alternatives:

Using a Folder Library:
See the ShowFolderPics file at this link:
http://www.contextures.com/excelfilesRon.html#RCH0002

Using pictures stored in the workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

Post back with more questions.

ALWAYS 4 pictures?...or....UP TO 4 pictures?

I'm envisioning a set up that involves a LookUp table:
Col_1: JobID (eg J102a)
Col_2: JobDesc (Replace Kniffle Pin Extender)
Col_3: Pic_1_Location (eg C:\JobPics\J102a_KPE_Pic.jpg
Col_3: Pic_2_Location (eg C:\JobPics\J102a_Machine3_Pic.jpg
Col_3: Pic_3_Location (eg C:\JobPics\J102a_M3_CoverRemoval_Pic.jpg
Col_3: Pic_4_Location (eg C:\JobPics\J102a_TagSignOff_Pic.jpg

Using that set up, you could have a Data Validation drop-down list, sourced to either the JobID field or the JobDesc field.

Any change to the value of that DV cell would trigger a macro that would purge the current 4 pictures and replace them with the 4 that pertain to the job.

Your thoughts?

If you don't mind, I'll throw together a Proof of Concept model. We can play with that to get it functional in a basic way. After that, you'll be able to own it and adapt it as necessary.

(Don't you just love this stuff! I do.)

OK, my friend.....Let's see how I did:

First, a bit of set up
1) Create this folder:
C:\JobPicLib

2) Download the 2 JobPics zip files and extract the 6 stupid pics I posted into that folder.

3) Download the ShowJobPicsDemo_v1_0_0.zip file

4) Extract the ShowJobPicsDemo_v1_0_0.xls file and save it.

Second, a few notes about the file
1) LU_DisplayName and LU_Name_FileLoc_XRef are Dynamic Range Names. They automatically expand and contract to accommodate the number of jobs listed.

2) If there are no pics for a Job or the references are invalid...it just removes the previous pics (if there were any)

3) Use the 1st item in the drop-down list ("(Clear the Form)" to clear the current pictures.

That's about it.

Your thoughts?

The model uses the below named ranges

Please Login or Register  to view this content.

See how you do....Post back with more questions.