Inserting multiple pictures

**fourwhls** · 03-17-2009, 04:57 PM

Excel 2000

I am having some trouble with the vba code I'm using to reference pictures. Now please bear with me, I'm don't know vba whatsoever and am copy/pasting what I found on the internet.

The spreadsheet in question is attached....

The issue:
I am trying to show a picture based on the inputs in the cells above. Basically the picture in cell A28 is referenced by the information in cell AI7. The picture in cell D28 should be referenced by the information in cell AI8 and so on.

The problem is that when I enter the code to insert multiple pictures, it comes up with errors.

I'm hoping this is just my lack of programming knowledge and this is an easy fix. Please tell me where I am going wrong.

Also, will there be an issue if I reference the same picture multiple times?

Any and all help is greatly appreciated.

**fourwhls** · 03-19-2009, 06:40 AM

I'm still looking for some help!!

I found a thread that should solve my issue, but I can't get it to work. Here's a link to that thread: http://www.excelforum.com/excel-prog...-pictures.html

**fourwhls** · 03-19-2009, 02:16 PM

Should I assume that nobody is able to help?

**Andy Pope** · 03-20-2009, 05:20 AM

This will not get around the problem of having to display the same picture in 2 places but it will display the pictures for both test cells if unique.

One of your problems is that you created 2 calculate events. Instead what you need to do if place both sets of code in the 1 event.

This checks A28 and D28 content. Making the picture visible and placed correctly if the name matches

Please Login or Register  to view this content.

**fourwhls** · 03-20-2009, 09:51 AM

Andy,
I appreciate the reply, but unfortunately I am still not able to move forward. I need to be able to display the same picture multiple times.

Is it possible to use some version of the code that your wrote here?: http://www.excelforum.com/excel-prog...-pictures.html

**Andy Pope** · 03-20-2009, 10:21 AM

This code in a standard code module.

Please Login or Register  to view this content.

This revised Calculate event code

Please Login or Register  to view this content.

Obviously you need to add and name pictures for all shaft arrangements

**fourwhls** · 03-20-2009, 10:48 AM

Andy,
You are my hero! If you are ever on this side of the pond...beer is on me.

Thanks,
Shawn

**smartty4all** · 06-17-2010, 07:42 AM

This is in regards to the link below.

http://www.excelforum.com/excel-prog...-pictures.html

In the attachment I do not understand where are the photo's coming from ? Please help

Regards,
Mahipal

**fourwhls** · 06-17-2010, 12:46 PM

Originally Posted by smartty4all

This is in regards to the link below.

http://www.excelforum.com/excel-prog...-pictures.html

In the attachment I do not understand where are the photo's coming from ? Please help

Regards,
Mahipal

Mahipal,
There is only one pictured referenced in the spreadsheet attached to the original post. The pictures can be physically placed anywhere within the spreadsheet.

I have attached the final spreadsheet. Look at the REF tab (which is hidden) and you will find all the referenced pictures.

Hope this helps

**dougjsmith11** · 05-24-2011, 07:04 PM

Andy,

I have used your code at the top of the page (the shorter one) to lookup multiple pictures. It works great. However I have one question, is there a way to have the picture centered in the cell? I am not an expert on VBA, but by looking at your code, it looks like its moving the picture to the TOP and LEFT of the cell. I tried to change the words to Center, but that didn't work. Is there a solution to this? Thank you.

Inserting multiple pictures

LinkBack

Thread Tools

Rate This Thread

Display

Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Re: Inserting multiple pictures

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions