HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?

[labouche10]

HELLO ALL.

I HAVE AN EXCEL DOCUMENT THAT I AM USING TO GENERATE ARTWORK FOR
PACKAGING. AS FAR AS TEXT IS CONCERNED EVERYTHING HAS WORKED OUT GREAT
USING VLOOKUP ETC. MY MAIN PROBLEM IS THOUGH THAT IN ONE SPOT ON THE
ARTWORK AN IMAGE MUST BE DISPLAYED. THE IMAGE DISPLAYED VARIES BASED ON
INFORMATION STORED ON A DIFFERENT SHEET(SAME WORKBOOK). ALL IMAGES IN
QUESTION ARE NAMED ACCORDINGLY AND STORED ON AN ADDITIONAL SHEET IN THE
WORKBOOK AS WINDOWS METAFILE FORMAT.

I DIDN'T WANT TO USE THE REPLACING GRAPH DATA POINTS WITH PICTURES
TRICK ON THIS ONE. ANYWAY I WANT TO LEARN VBA REALLY BAD! I HAVE A BOOK
ON ORDER BUT SURE WOULD LOVE SOME HELP. I'M NORMALLY A QUICK LEARNER!!.

THX
MIKE

 

[Mike]

BTW I'M USING EXCEL 2000

THX
MIKE

 

[Norman Jones]

Hi Mike,

See the techniques used by JE McGimpsey at:

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


BTW, the exclusive use of upper case renders your post difficult and
unpleasant to read. Additionally, in some quarters, such use is regarded as
tantamount to shouting.

 

[Tom Ogilvy]

Perhaps this site:
http://www.mcgimpsey.com/excel/lookuppics.html

JE McGimpsey's site.

 

[Mike]

Norman,

Thank you for your help and I apologize for the quick typing in CAPS. I
will try this and let you guys know.

Thx
Mike