How to show Images in a Cell based on a condition?

**e4excel** · 12-02-2009, 10:16 AM

Dear Forum,

I am aware of the option of displaying an Image/Picture via comment but I need to show a picture based on a condition..

I tried manually selecting the picture from the path mentioned below :

"C:\Documents and Settings\Administrator\My Documents\My Pictures"

I have 2-3 images that I want to display based on a condtion when the time turns 16:00 hrs then the First Image Should be displayed, when it turns 16:30 hrs then the second and 17:00 the last image.

I tried researching the forum, however none of the threads provided an option to to add my Images..which can be later viewed...

So how do I do this?

**e4excel** · 12-02-2009, 02:54 PM

Dear Forum,

Unfortunately have not got a response till now , however I have been able to know how to Insert a Picture in the Sheet which I was completely ignorant about... That's the one good thing and the other is digging this good post form an earlier response..

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

I am refferring to the #2 post in this thread by Andy Pope who has attached a filw which works fantastically and to top it all--Its a NOn-VBA Solution..

But the worst thing is I dont see any formulas anywhere which makes it work and therefore do not know how to display the Images.

Can someone please help me based on this as I have added that file fore reference....

Regards
e4excel

**e4excel** · 12-03-2009, 08:19 AM

Dear Forum,

Can someone please try to help me out here as i have found a Website which has a file doing what Im looking out for , however Im not able to customise it to my requirements if some good soul could spare a minute of rew to just explain as How do I put my Pictures in this file to be able to make them visible based on a condition..

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

I reffered this website high and low but could not figure wher I need to store the images..

Please someone can tell me that...

REgards
E4excel

**e4excel** · 12-03-2009, 10:03 AM

Unfortunately didnt receive help this time, but ultimately perseverance paid off...

I was not able to get the missing link but accidentaly managed to get it!
Though it was very simple...

I just had to Name all the Images in the Corner which I was failing to do and after that zoom it was working..!

Eureka...Kind of

**e4excel** · 12-04-2009, 12:33 AM

Hi,

Luckily for me I got the Concept and how to employ it however, when I tried to make a completely new file..

I am gettting an Error
Run Time Error '13':
Type Mismatch

and after pressing Debug
I get this line Marked Yellow-- "Next oPic"

The entire VBA Code is :

Please Login or Register  to view this content.

Can someone please tell me what changes do I need to make?

I ahve around 8 Images stored as Picture 1,..,.. Picture 8 etc.
But after Selecting the Dropdown it works only for the first Image i.e Picture 1gets displayed , however all the subsequent images throw an error..

I am not good in VBA butt just try to copy the code and understand the same..So please provide explanation..

Warm Regards
e4excel.

**e4excel** · 01-12-2010, 09:06 AM

Dear Forum,

There was an error, due to my several tries of adding the images there was a cluster of these images which were invisible on execution and therefore not tracked and then when I changed the code to check all the Images I realized my folly and immediately deleted the Images and Inserted new Images with the Name "Picture 1, 2 , 3 etc.. and then it worked well..

Just want to mention that..!

**e4excel** · 01-13-2010, 03:39 AM

How do I mark this thread as Solved?
I am not getting an option in the first thread "Edit"?

Can someone please help me on the same?

**contaminated** · 01-13-2010, 03:45 AM

I've just posted somethig similear here
Please take a look

**e4excel** · 01-13-2010, 03:58 AM

Hey thanks a lot contaminated!

That's what i was looking out for and really lucky of me for you to just check my thread and repsond..

Never too late to receive help...

Thanks for the link..

**e4excel** · 01-13-2010, 05:22 AM

How do I mark this thread as Solved?
I am not getting an option in the first thread "Edit"?

Can someone please help me on the same?

**e4excel** · 01-20-2010, 09:50 AM

Bump no response

How do I mark this thread as Solved?
I am not getting an option in the first thread "Edit"?

Can someone please help me on the same?

**e4excel** · 11-27-2010, 10:14 AM

Dear Contaminated!,

I am trying to follow the instructions mentioned in your earlier post, however I am not able to implement them..

Could you or someone who has an idea on the same throw some light on the same..

HTML Code:

Regards

**e4excel** · 11-28-2010, 07:25 AM

Dear Forum,

I am trying to get to this, however finding it difficult and in vain even though I am folllowing each and every step the way mentioned in the site..

I have Excel 2007...
Please find the below link which is a video in getting a Picture Lookup without VBA..

http://www.youtube.com/watch?v=1_6nG24sZOg

I am trying to follow the Latter portion in the Video without the comment and have tried to follow exactly the way mentioned but in avin..

Please find the attached file..

**e4excel** · 11-29-2010, 06:42 AM

Dear Forum,

Please I just need advice as to whats the reason that inspite of following everything verbatim I am not able to achieve what is shown..

Please please..!

**e4excel** · 11-30-2010, 01:42 PM

Dear Forum,

Please I just need advice as to whats the reason that inspite of following everything verbatim I am not able to achieve what is shown..

Please please..!

Someone be kind enought to help me out!

**e4excel** · 12-01-2010, 03:31 PM

I tried this link..

http://www.youtube.com/watch?v=1_6nG24sZOg

too!

But as shown it does not accept the Image Name..

If I put individual Pictures as Names then it works but that is not what is shown in the presentation,,

So what is that I am missing!

**e4excel** · 12-01-2010, 04:28 PM

If I create this way by creating different names of the belwo:

Name
BOB
Carol
Ted
Alice

It works but when I tried using the formula
NAme > Image = INDIRECT("Sheet2!$C$C"^VLOOKUP(Sheet1!$A$1,PicTable,2,0))

**e4excel** · 01-12-2011, 03:04 PM

Dear Forum,

Finally Got It,

Eureka...

It was so simple but just got complicated with me strangely and importantly its NON_VBA simple NAME ranges and Data Validation List and Camera Tool...

Just for the readers to make it useful..

1. Create a list of Picture Names and Pictures Next to it in the adjoining column in a Sheet renamed as Picture Database
Ex:- Col A - Picture Name & Col B - Pictures.

2. Remove any Borders and Remove Gridlines in the above sheet..
Name - >

Please Login or Register  to view this content.

3. In any other sheet named Selection - create a simple dropdown with the List of all names as shown below:
Name - >

Please Login or Register  to view this content.

4. Select any cell with a Picture in it the Picture Database sheet and then click on the Camera Icon in Excel 2007 and then paste in the Selection sheet in a cell where you owuld like the dynamic pictures to appear and immediately rename it to Picture.. if you have de-clicked it please click again and the formula toolbar just add as =Picture and there you go..

5. Try selecting any other name and you would get a different picture for every selection..

Wow..So cool....

Regards
E

**e4excel** · 01-12-2011, 03:07 PM

Dear Mod,

I am unable to Mark the query as SOLVED as theres no EDIT option available..

Thanks in advance.
E

**tssrshot** · 04-05-2011, 02:28 PM

Yikes, I hate to bring up old stuff, but I've been working on a document we all use at my work here. I've managed to tailor the image examples given to get basic functionality going, but now it seems to randomly choose two of my pictures and scrunch them together or grab up some text from either side of the designed image.

Anyone have clue on how to get a more uniform look? The example is a little messy now since ive been dragging some stuff around to try and troubleshoot. I'm also in the works of doing the image selection on another pull down for changing the bottom logo, but first things first.

File is too large for attaching to the forum, so:

Hours Tracker Beta.XLSM

Thanks for you advice at this time!

Bryan

**ruznemat** · 08-15-2014, 08:00 AM

Hi, i wrote this code today. but i wrote this to myself. there are 4 images on the sheet1. But it displayed one of them and keep changed every 4 sec.

Please Login or Register  to view this content.

How to show Images in a Cell based on a condition?

LinkBack

Thread Tools

Rate This Thread

Display

How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Bump no response!

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Bump No response

Bump No response

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Re: How to show Images in a Cell based on a condition?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions