Hi there,

I have a database of items, and each items have a picture attached to
it.
On the interface itself, i will use the lookup function to pick out
some items from the database, but i want to picture to come with the
lookup results. how can i do it?

I had tried putting pictures into the comment box of each item, but
when i lookup these items, the comment box do not come together, so i
do not know what else i can do.

Please advice. Thank you.

See

http://www.mcgimpsey.com/excel/lookuppics.html

In article .com,
"WL" wrote:

Hi there,

I have a database of items, and each items have a picture attached to
it.
On the interface itself, i will use the lookup function to pick out
some items from the database, but i want to picture to come with the
lookup results. how can i do it?

I had tried putting pictures into the comment box of each item, but
when i lookup these items, the comment box do not come together, so i
do not know what else i can do.

Please advice. Thank you.

I've been to the site as recommended, but how do i link the picture
name, ie picture 1, to the picture on sheet 1?

The result given was simply the text Picture 1

Use whatever the picture's named. You can see the picture name by
selecting it and looking in the Name box at the left side of the Formula
Bar.


In article .com,
"WL" wrote:

I've been to the site as recommended, but how do i link the picture
name, ie picture 1, to the picture on sheet 1?

I did that, but the result is still the text. i.e. Picture 2.

Do i have to do anything to the PicTable on Sheet 2 (picture name) or
simply type in the Picture name.

Please advice. Thank you

using the Picture's name should be sufficient. Is the Event macro firing?

In article .com,
"WL" wrote:

I did that, but the result is still the text. i.e. Picture 2.

Do i have to do anything to the PicTable on Sheet 2 (picture name) or
simply type in the Picture name.