+ Reply to Thread
Results 1 to 2 of 2

Linking a cell to a jpeg image

  1. #1
    Registered User
    Join Date
    02-18-2012
    Location
    Geelong Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Linking a cell to a jpeg image

    HI - I am wondering how I can have an Excel spreadsheet with a small cell active such that when I click on it, a image/picture appears on the screen. I have a price list and I want to be able to see an image of the product item by clicking on it or moving the mouse over the cell. I cant have the full size of the image in the price list as it would make the price list too big. The images are in JPEG format. I dont think I can copy the images to a spreadsheet either. Any help would be much appreciated
    kind regards
    Darren

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Linking a cell to a jpeg image

    Will the folder with the jpg's in it, be available to every1 who has access to the workbook?

    Because if so, the following formula will create a hyperlick to pictues. This particular 1 works by referencing the picture file name, so that you can copy it for a range of pics, and add to it if you add extra pics. If is it just 1 or 2 pics, then you could probably do away with the formula and just use the link.

    =IF(B172="","",HYPERLINK("S:\the_path_to_your_pictures\"&B172&".jpg"))

    Hope this helps
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1