+ Reply to Thread
Results 1 to 2 of 2

Calling Picture Files

  1. #1
    Registered User
    Join Date
    09-29-2008
    Location
    Honolulu
    Posts
    4

    Calling Picture Files

    How do you make Excel call up a picture file based on the value in a cell?
    For example:

    A1 = cat
    A2 = dog
    A3 = bird

    When A1 is selected cat.jpg is called up. When A2 is selected dog.jpg is called up. A3, bird.jpg. And can this picture be positioned?

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sure one of these should help

    http://www.mcgimpsey.com/excel/lookuppics.html
    http://www.jkp-ads.com/Articles/ShowPicture00.htm
    http://www.andypope.info/fun/picviewer.htm
    Under the heading ....Insert Pictures from Folder
    Under the heading ....Add Comments With Picture

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create a macro that will run a filter, of all 5 files against the picture column
    By ajhaspel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2008, 01:30 PM
  2. Trying to move all xls files from one folder to another
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2008, 10:39 AM
  3. Import Specific line from multiple text files
    By Vlad999 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2008, 06:50 PM
  4. Store Bitmap Object In Excel 2003 To Access Database?
    By Soar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2008, 02:13 AM
  5. Linking external picture files??
    By georgeslou in forum Excel General
    Replies: 1
    Last Post: 11-17-2006, 02:47 PM

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