project work - Managing images by clicking on cell/text ??

[Macke3]

Hello,

I'm working on a small project and need some help to make some functions work, it is probably something simple but I'm not very advanced on excel so any help is greatly appreciated.

Here it is, I'm working on a simple satellite coverage sheet in which I list all the available satellites and their coverage area (saved images), I would like to know how can I write a command to change the map picture every time I click on a different satellite name, here is a screenshot of my sheet -

http://img.auctiva.com/imgdata/2/0/6...59389879_o.jpg

I would like the coverage map to change everytime I click on a different satellite name, ie -

http://img.auctiva.com/imgdata/2/0/6...59385246_o.jpg

Ideally I would like to click on the satellite name text and change the map, or the actual cell would do as well.


Also is there a way to store all the images on a separate sheet and make them HIDDEN to the end user ?

http://img.auctiva.com/imgdata/2/0/6...59390021_o.jpg


Again any help is greatly appreciated

Thanks
-Macke

[teylyn]

Hi Macke,

I'm not quite sure about clicking on a name and displaying a picture. But if you could add another field that has a list of satellites and the user would select from this which satellite to display, then you could use the method described here:

http://www.jkp-ads.com/articles/ShowPicture00.asp

have a look and play around with it some. maybe you'll get some ideas.

cheers