Gord,

i didn't explain myself properly.

i copied the code and the formulas from the site and off course changed the
names of the pictures to my own pictures.

but when i start selecting with the dropdown list in the first sheet all
pictures dissapear nomatter what selection i perform.

Grts,
Tom

"Gord Dibben" wrote:

Tom

JE's example workbook should be downloaded so's you can have a look at how he
has done it.

As designed, only the picture associated with the DV dropdown choice will be
shown.

The rest are hidden.

Perhaps not what you needed?

Do you wish each picture to remain in view after it has been chosen from the
dropdown list?

The event code would have to re-written in order for that to occur.


Gord

On Sat, 13 Jan 2007 06:28:00 -0800, Tom Vandewiele
wrote:

Gord,

I tried the solution on the JE McGimpsey's site but i can't get it to work
fully. When i run the code the pictures dissapear, like they can't be found.

Could i maybe send you my excel file ?

Greets,
Tom



"Gord Dibben" wrote:

Tom

Programmatically............see JE McGimpsey's site for a method of showing
hidden pictures based upon a value in a cell. The value can be one of many in a
DV dropdown list.

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


Gord Dibben MS Excel MVP

On Mon, 1 Jan 2007 02:29:00 -0800, Tom Vandewiele <Tom
wrote:

Hi, i am a project manager trying to create a progress report in MS Excel
based on weather icons, these are small GIF's of sunny or cloudy weather. I
would like to create a dropdown list in the cells where a user can select the
relevant icon / gif.

is this possible ?

thanks,
Tom