Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?

BTW I'M USING EXCEL 2000

THX
MIKE

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
1 image printing as 2 images working New Users to Excel 2 June 21st 06 10:10 PM
Is there any way to display URL images in an Excel spreadsheet? kennyharrill Excel Discussion (Misc queries) 0 March 13th 06 09:04 PM
Userform Image Control and embedded images tim Excel Programming 13 April 5th 05 01:32 PM
Inserting CGM images in Excel changes image aspect ratio Dinesh[_3_] Excel Programming 0 July 28th 04 09:47 PM
copy shape image into image control Luc Benninger Excel Programming 2 July 15th 04 11:14 AM


All times are GMT +1. The time now is 12:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"