+ Reply to Thread
Results 1 to 5 of 5

adding pictures depending on value

  1. #1
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    adding pictures depending on value

    hi all,

    i have a value in a cell ranging from 1 to 5.... i want to be able to display a quantity of pictures depending on the value.

    ie if a1=1 then display untitled1.jpg
    if a1=2 then display untitled1.jpg and untitled2.jpg


    etc

    is this at all possible

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: adding pictures depending on value

    Hope life's good in Sunny Nunny.

    Yes, it's possible, but where are the pictures? It iwll be quite complicated, requiring macros. Are you ok with that?
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    Re: adding pictures depending on value

    im not good with macros but i can copy paste ok..lol.... if you default the picture directory to u:\\my pictures then i will ammend as needed.


    thanks in advance

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: adding pictures depending on value

    Enjoy...
    Please Login or Register  to view this content.
    Edited: I made it fit your requirement better...
    Last edited by Cheeky Charlie; 02-22-2013 at 12:42 PM. Reason: Slightly more helpful version

  5. #5
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    Re: adding pictures depending on value

    thanks charlie, will look at this now. sorry for not looking sooner.

+ 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