HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?

  • Thread starter Thread starter labouche10
  • Start date Start date
L

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
 
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
 
Back
Top