Pulling Images From Disk

**livewire401** · 08-07-2011, 05:42 PM

I've been trying to create a system where the user uses a drop down list on Sheet1 to select and option that displays an image on Sheet2 and I'd like to store any needed data to do this in cells on Sheet3. I've been using the following code pulled from contextures.com

Please Login or Register  to view this content.

With the following module

Please Login or Register  to view this content.

This works (and was designed for) when all the info and selection is done on one sheet. I just need it to work when the relative pieces are separated on several sheets as mentioned above. Any help would be much appreciated.

**TMS** · 08-07-2011, 05:58 PM

A sample workbook or a link to the Contextures example would be helpful.

Regards

**livewire401** · 08-07-2011, 06:01 PM

Sorry about that. Here is the original file I pulled the code from.

http://www.contextures.com/ShowFilePicsDemo.zip

**livewire401** · 08-08-2011, 02:00 PM

Bump no response

**livewire401** · 08-09-2011, 06:05 PM

Some progress. I'm using what I think will be a simpler solution.

Please Login or Register  to view this content.

This allows me to use a drop down menu on Sheet1 to pick from a list of file names on Sheet3. So far so good. The code above drops the image into Sheet1. What I'd like to to do is specify an location on Sheet2 to insert the image.

Any help would be greatly appreciated!