Popup File

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
A

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
 
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.
 
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
 
Yes,
Thanks
Amnon
trip_to_tokyo said:
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.
Click to expand...
 
Back
Top