Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
BTW I'M USING EXCEL 2000
THX MIKE |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
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. --- Regards, Norman wrote in message oups.com... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
Perhaps this site:
http://www.mcgimpsey.com/excel/lookuppics.html JE McGimpsey's site. -- Regards, Tom Ogilvy "Mike" wrote in message oups.com... BTW I'M USING EXCEL 2000 THX MIKE |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1 image printing as 2 images | New Users to Excel | |||
Is there any way to display URL images in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Userform Image Control and embedded images | Excel Programming | |||
Inserting CGM images in Excel changes image aspect ratio | Excel Programming | |||
copy shape image into image control | Excel Programming |