Hide Or Show An Image Based On A Cell Value

**kc27315** · 03-31-2009, 05:40 PM

I have a spreadsheet with two bitmap images inserted into it. In cell E2, I will enter a number, either a 1 or a 2. if I enter a 1, I want only the first image to be visible. If I enter a 2, I only want the second image to be visible. Is there a way to accomplish this (hopefully without the need for macros)? I've attached a spreadsheet as an example of what I'm trying to do. Also, note that I'd like the images to be stacked on top of each other so that they show up in the same place regardless of wether there's a 1 or a 2 in cell E5

Any help is greatly appreciated.

kc

**kc27315** · 03-31-2009, 05:50 PM

FYI, the two images were made using Insert/Object/Create from File, and then using a bitmap image I created in Microsoft Paint.

kc

**shg** · 03-31-2009, 06:05 PM

To do exactly what you're asking would require code. For an alternative, see http://www.mcgimpsey.com/excel/lookuppics.html

**kc27315** · 03-31-2009, 06:21 PM

Thank you so much. I guess I'll just have to bite the bullet and use code. I appreciate your help.

kc

**Trebor76** · 03-31-2009, 06:22 PM

Hi kc27315,

You should consider changing the title of your thread to be more descriptive of your problem to help others searching for an answer to this (or a similar) issue - something like "Hide Or Show An Image Based On A Cell Value".

That said, the only way I can think of doing this is via a Worksheet_Change macro which I've code on the attached. Note I've also included a data validation entry in cell E2 to help ensure the reliability of the macro.

HTH

Robert

**shg** · 03-31-2009, 06:40 PM

I like Trebor's suggestion, and am changing the title.

Please take a little more time in composing thread titles, kc.

**Cullen8** · 04-01-2009, 05:27 PM

Here is a way to change a pic without a macro. Do they have to be bitmap images?

Thanks,
cullen

**martindwilson** · 04-01-2009, 06:39 PM

very clever , now how is that done?

**Cullen8** · 04-02-2009, 12:24 PM

Sorry for not explaining in the original post.

If you look at the workbook posted check the named ranges. In Sheet 2 you have your two images and the ranges "Newton" & "Einstein".

when you select the image in the formula bar there was =Enbed("bitmap images","") (something like that i don't remember) but that has to be cleared out.

On Sheet 1 on your image change the formula from above to =showmypic

Behind the image i created a formula off of E2 in C6 =CHOOSE(E2,"Newton","Einstein")

In your name manager create a range with a name "showmypic" in the formula =INDIRECT(Sheet1!$C$6)

Hope this helps,
Cullen

**shg** · 04-02-2009, 12:50 PM

Very clever, Cullen, thanks.

**raveepoojari** · 04-04-2009, 05:30 AM

really nice idea MR. Cullen..but i didnt get excat idea. if i want to put more 5 photos how can i use? btw in sheet 2 u inserted picture and metioned name? once selte the photos in sheet2 its showing photos name. how did u mentioned there. even i tried add one more photo..but i didnt able to give name for this photo in sheet2.

plz suggest me properly...

thank u in advance and excuse for bothering u

**Cullen8** · 04-06-2009, 11:54 AM

Hi Raveepoojari,

Once you have copied your pic to sheet two select the cells behind the pic and go to -- Insert-Name-Define -- and create a new range for your pic.

In Sheet one you should only have to change the Choose formula to add the new named range.

Thanks,
Cullen

**raveepoojari** · 04-06-2009, 12:35 PM

really nice idea man..

btw thank u

**rbyrd023** · 09-23-2009, 09:29 AM

This was just pure genious and has worked for me many times. However I am creating a new workbook on a different computer and after I print the page the pictures shrink down to little of nothing. It is getting very frustrating. Any thoughts on how to fix that?

**yeh1985** · 01-04-2011, 09:34 AM

Thank...really looking forward for this answer.

**alejaraluc** · 11-17-2012, 01:51 PM

It's so simple once you understand how the method works!
The =INDIRECT() formula was unkown to me, but seems to have many other useful applications.
You sir have just changed the way I go about building spreadsheets.
Thank you, I'm very impressed!

**Chaylon** · 07-23-2020, 08:47 PM

I do not understand, I am unable to add a formula to the image itself, it mostly gives me only options to format the image.

**alejaraluc** · 07-24-2020, 01:55 PM

To do that, you have to paste the image as linked picture. Then, when you select it, you should see the reference in the formula bar. You can paste the formula indicated previously there. Cheers!

**otaru** · 10-23-2020, 01:39 AM

Thank u very much. I finally understand the steps.

**Prateeksha11** · 04-25-2023, 11:19 AM

Hi,

How would I show no image if the criteria is not met? I'm only able to switch between different images.

**FDibbins** · 04-25-2023, 11:06 PM

Originally Posted by Prateeksha11

Hi,

How would I show no image if the criteria is not met? I'm only able to switch between different images.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**Kamarbasha** · 06-12-2023, 03:55 AM

in the active sheet you are working with, open VBA and paste the following code in the active sheet (e.g. sheet1):

Please Login or Register  to view this content.

This VBA code works even with gif and doesn't affect the size of the excel file.

Hide Or Show An Image Based On A Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Hide Or Show An Image Based On A Cell Value

re: Hide Or Show An Image Based On A Cell Value

re: Hide Or Show An Image Based On A Cell Value

re: Hide Or Show An Image Based On A Cell Value

re: Hide Or Show An Image Based On A Cell Value

re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Re: Hide Or Show An Image Based On A Cell Value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions