software

K. I will try and explain this the best I can.

I am creating a database based on ships.
I have around 50 thumbsized images and I have resized a cell to fit these
images in the main page that gives information about each ship.
I need this cell to be able to change the image each time the name of the
ship changes.
I can't store these images on my HD and link to them as other people useing
the database would have to have the same images as well.
I would like to paste all the images into a seperate sheet in the workbook.
The only way I can think of doing this would be to lock an image to a cell
and then use something like VLOOKUP but I can't find a function that allows
you to lock an image to a cell.

Any help on this would be apreciated.

Thank you.

hyperlinks
--
paul
remove nospam for email addy!
quot;barry24ukquot; wrote:

gt; K. I will try and explain this the best I can.
gt;
gt; I am creating a database based on ships.
gt; I have around 50 thumbsized images and I have resized a cell to fit these
gt; images in the main page that gives information about each ship.
gt; I need this cell to be able to change the image each time the name of the
gt; ship changes.
gt; I can't store these images on my HD and link to them as other people useing
gt; the database would have to have the same images as well.
gt; I would like to paste all the images into a seperate sheet in the workbook.
gt; The only way I can think of doing this would be to lock an image to a cell
gt; and then use something like VLOOKUP but I can't find a function that allows
gt; you to lock an image to a cell.
gt;
gt; Any help on this would be apreciated.
gt;
gt; Thank you.

Using a Hyperlink will not work. Hyperlinks will take you to a place that you
link to same as it does on a webpage.quot;paulquot; wrote:

gt; hyperlinks
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;barry24ukquot; wrote:
gt;
gt; gt; K. I will try and explain this the best I can.
gt; gt;
gt; gt; I am creating a database based on ships.
gt; gt; I have around 50 thumbsized images and I have resized a cell to fit these
gt; gt; images in the main page that gives information about each ship.
gt; gt; I need this cell to be able to change the image each time the name of the
gt; gt; ship changes.
gt; gt; I can't store these images on my HD and link to them as other people useing
gt; gt; the database would have to have the same images as well.
gt; gt; I would like to paste all the images into a seperate sheet in the workbook.
gt; gt; The only way I can think of doing this would be to lock an image to a cell
gt; gt; and then use something like VLOOKUP but I can't find a function that allows
gt; gt; you to lock an image to a cell.
gt; gt;
gt; gt; Any help on this would be apreciated.
gt; gt;
gt; gt; Thank you.

quot;A hyperlink is a link from a document that opens another page or file when
you click it. The destination is frequently another Web page, but it can also
be a picture, or an e-mail address, or a program. The hyperlink itself can be
text or a picture.quot;--
paul
remove nospam for email addy!
quot;barry24ukquot; wrote:

gt; Using a Hyperlink will not work. Hyperlinks will take you to a place that you
gt; link to same as it does on a webpage.
gt;
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; hyperlinks
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;barry24ukquot; wrote:
gt; gt;
gt; gt; gt; K. I will try and explain this the best I can.
gt; gt; gt;
gt; gt; gt; I am creating a database based on ships.
gt; gt; gt; I have around 50 thumbsized images and I have resized a cell to fit these
gt; gt; gt; images in the main page that gives information about each ship.
gt; gt; gt; I need this cell to be able to change the image each time the name of the
gt; gt; gt; ship changes.
gt; gt; gt; I can't store these images on my HD and link to them as other people useing
gt; gt; gt; the database would have to have the same images as well.
gt; gt; gt; I would like to paste all the images into a seperate sheet in the workbook.
gt; gt; gt; The only way I can think of doing this would be to lock an image to a cell
gt; gt; gt; and then use something like VLOOKUP but I can't find a function that allows
gt; gt; gt; you to lock an image to a cell.
gt; gt; gt;
gt; gt; gt; Any help on this would be apreciated.
gt; gt; gt;
gt; gt; gt; Thank you.

Paul,
As much as I apreciate you trying to help me out on this matter,
hyperlinking realy is not the solution to my qestion.
I know what a hyperlink is, I know what they are used for and I also know
how to use them.
I want to be able to update the information on an entire sheet by selecting
a name from a dropdown menu.
This information is stored on another sheet in the same workbook.
I don't want to go to the image, I want to pull the image into the sheet and
I want that image to change when I select a different name from the dropdown.
Now if you know of a way where if I was to store the hyperlinks to all the
images and then get a single cell to be able to not just display that link,
but to actualy activate it and grab the image of the net...
Then that is exactly what I am looking for.

Hopefuly, this better explains what it is that I am trying to do.

But again... Thank you for your responce.
quot;paulquot; wrote:

gt; quot;A hyperlink is a link from a document that opens another page or file when
gt; you click it. The destination is frequently another Web page, but it can also
gt; be a picture, or an e-mail address, or a program. The hyperlink itself can be
gt; text or a picture.quot;
gt;
gt;
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;barry24ukquot; wrote:
gt;
gt; gt; Using a Hyperlink will not work. Hyperlinks will take you to a place that you
gt; gt; link to same as it does on a webpage.
gt; gt;
gt; gt;
gt; gt; quot;paulquot; wrote:
gt; gt;
gt; gt; gt; hyperlinks
gt; gt; gt; --
gt; gt; gt; paul
gt; gt; gt; remove nospam for email addy!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;barry24ukquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; K. I will try and explain this the best I can.
gt; gt; gt; gt;
gt; gt; gt; gt; I am creating a database based on ships.
gt; gt; gt; gt; I have around 50 thumbsized images and I have resized a cell to fit these
gt; gt; gt; gt; images in the main page that gives information about each ship.
gt; gt; gt; gt; I need this cell to be able to change the image each time the name of the
gt; gt; gt; gt; ship changes.
gt; gt; gt; gt; I can't store these images on my HD and link to them as other people useing
gt; gt; gt; gt; the database would have to have the same images as well.
gt; gt; gt; gt; I would like to paste all the images into a seperate sheet in the workbook.
gt; gt; gt; gt; The only way I can think of doing this would be to lock an image to a cell
gt; gt; gt; gt; and then use something like VLOOKUP but I can't find a function that allows
gt; gt; gt; gt; you to lock an image to a cell.
gt; gt; gt; gt;
gt; gt; gt; gt; Any help on this would be apreciated.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you.