Display a picture depending on a value in a specified cell?

[Rakel]

Hello,
Is there anyone here that can help me to find out how I can display a
picture depending on a value in a specified cell?
I have a drop down list with 7 values and I want the picture to
reflect what is chosen in the drop down list (7 different pictures).
Any clues as how to solve this problem?

 

[Tom Ogilvy]

Bernie Deitrick just responed to a similar question by sending a sample
workbook to the poster. You could send him an email asking for a copy or
perhaps he will respond here.

From: "Bernie Deitrick" <deitbe @ consumer dot org>
References: <[email protected]>
Subject: Re: Case# 4812 - Display gif picture based on cell content
Date: Thu, 17 Jun 2004 08:09:57 -0400
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <[email protected]>
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: 65.90.194.200
Path: TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.excel.programming:515925

Bjorn,

I will send you an example workbook that uses the workbook's events to
change graphics based on cell content.

HTH,
Bernie
MS Excel MVP