Results 1 to 4 of 4

Thread: EXCEL question

  1. #1
    Member
    Join Date
    Aug 2003
    Location
    Wellingborough, Northants
    Posts
    158
    Thanks
    7
    Thanked
    0 times in 0 posts

    EXCEL question

    I have a friend who wants to display a picture (actually a range of pictures) on a spreadsheet which changes if the value (read model number) os picked from a list. This will give the reader a nice picture of the model or version of the motorbike he is thinking about.
    The list is probabaly going to be 'dates when the model was introduced' and MK1, MK II , that kind of thing, it actually makes no difference I suppose.
    The pic can be somewhere else on the spreadsheet.

    Any ideas?
    All I can think of is a simple IF(A1=1,C1,0) but that only returns a numeric value.......
    I can't think of what to use to make the content of C1 be a picture.....

    Cheers
    Rob
    The older I get, the faster I was.

  2. #2
    Senile Member
    Join Date
    Dec 2003
    Posts
    442
    Thanks
    3
    Thanked
    0 times in 0 posts
    Sounds like he should be using Access rather than Excel IMO.

  3. #3
    listen to escape fails :) luap.h's Avatar
    Join Date
    Jan 2004
    Posts
    569
    Thanks
    4
    Thanked
    2 times in 2 posts
    the only way I can think of at the moment is to use a picture box from the control panel. Then use macros to change the content based on a cell value.

    Image1 being the picture box, and A1 containing the motorbike name
    eg:

    Image1.Picture = LoadPicture("C:\bikes\Pictures\" & Range("A1").Text & ".jpg")

    if SR125 was in A1, the image c:\bikes\pictures\SR125.jpg would be loaded

  4. #4
    Member
    Join Date
    Aug 2003
    Location
    Wellingborough, Northants
    Posts
    158
    Thanks
    7
    Thanked
    0 times in 0 posts
    Many thanks, I am sure this is the way to go, but can't get it to work atm - too much wine !

    Cheers
    Rob
    The older I get, the faster I was.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. The 78th Annual Hexus Quiz!
    By Stewart in forum General Discussion
    Replies: 19
    Last Post: 23-01-2005, 02:05 PM
  2. SATA Question
    By Slick in forum PC Hardware and Components
    Replies: 3
    Last Post: 26-04-2004, 01:05 PM
  3. Silly Windows XP Question
    By evildoc614 in forum Software
    Replies: 2
    Last Post: 03-12-2003, 11:47 PM
  4. What is Question Time
    By Saracen in forum Question Time
    Replies: 0
    Last Post: 12-08-2003, 05:50 PM
  5. Essential Network Sharing Question
    By xfactor in forum Networking and Broadband
    Replies: 12
    Last Post: 03-08-2003, 11:00 PM

Posting Permissions

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