I have constructed a large data base of material samples and use the VLOOKUP
function to generate various forms and reports. I wish to include a bitmap
image on the form that changes with one of the variables. Simply put, if the
form is describing an apple, I'd like a picture of an apple, if describing a
pear, then a picture of a pear, and so on. I named the pictures and tried
bringing an image in with an IF statement but it only displayed the name I
assigned. Since there are only three bitmat images to display, I thought I
might accomplish this with conditional formating but I'm not sure how to turn
the image into a format shade. I'm kidda a "newby" at macro programming, but
I am willing to try it if it is the only solution.

Kindest Regards,

--
Dave B

Dave

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a value in a cell.

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



Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 20:27:00 -0800, Dave B
wrote:

I have constructed a large data base of material samples and use the VLOOKUP
function to generate various forms and reports. I wish to include a bitmap
image on the form that changes with one of the variables. Simply put, if the
form is describing an apple, I'd like a picture of an apple, if describing a
pear, then a picture of a pear, and so on. I named the pictures and tried
bringing an image in with an IF statement but it only displayed the name I
assigned. Since there are only three bitmat images to display, I thought I
might accomplish this with conditional formating but I'm not sure how to turn
the image into a format shade. I'm kidda a "newby" at macro programming, but
I am willing to try it if it is the only solution.

Kindest Regards,

Gord Dibben MS Excel MVP

Gord, Thanks for the link. This is exactly what I want to do. I downloaded
the sample and understand almost everything that is going on except.. where
are the pictures located. They aren't on a seperate sheet anywhere. They
have to be in the excel file, but I can find them.

If you are curious, you may wish to download the file. You will see what I
mean.

Anyway, I'll keep looking, thanks for your help

Best Regards,
--
Dave B


"Gord Dibben" wrote:

Dave

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a value in a cell.

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



Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 20:27:00 -0800, Dave B
wrote:

I have constructed a large data base of material samples and use the VLOOKUP
function to generate various forms and reports. I wish to include a bitmap
image on the form that changes with one of the variables. Simply put, if the
form is describing an apple, I'd like a picture of an apple, if describing a
pear, then a picture of a pear, and so on. I named the pictures and tried
bringing an image in with an IF statement but it only displayed the name I
assigned. Since there are only three bitmat images to display, I thought I
might accomplish this with conditional formating but I'm not sure how to turn
the image into a format shade. I'm kidda a "newby" at macro programming, but
I am willing to try it if it is the only solution.

Kindest Regards,

Gord Dibben MS Excel MVP