Popup File

[Amnon Wilensky]

Hi,

I have a list of workers and every one have a brief description stored in
JPG file format.

My question is: how can I build a worksheet with the workers name that when
clicking on a name will popup the related JPG file?

Using xp, Office 2003

Thanks,

Amnon

 

[trip_to_tokyo]

Try this:-

In cell A 1 put their first name (John for example)

In cell B 1 put their surname (Smith for example)

In cell C 1 insert a hyperlink (Insert / Hyperlink / and then put in the
full path name of where the .jpg file is, for example, c:\microsoft\test.jpg

All you have to do then will be to click in cell C 1 and the related JPG
file will pop up.

Please hit Yes if my comments have helped.

Thanks.

 

[Gord Dibben]

To have a picture show up based on VLOOKUP when you select an item from a DV
list or type in a name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed and the
pictures must be stored on the same worksheet as the VLOOKUP formula.

Or you need multiple pictures shown from VLOOKUPS.............

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures via selections.

Allows for more than one picture to be displayed on a sheet but also
requires the pictures be stored on same sheet.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP

 

[Amnon Wilensky]

Yes,
Thanks
Amnon

Try this:-

In cell A 1 put their first name (John for example)

In cell B 1 put their surname (Smith for example)

In cell C 1 insert a hyperlink (Insert / Hyperlink / and then put in the
full path name of where the .jpg file is, for example,
c:\microsoft\test.jpg

All you have to do then will be to click in cell C 1 and the related JPG
file will pop up.

Please hit Yes if my comments have helped.

Thanks.