Send the workbook to me Tom
Change the DOT and AT to get my email address.
Gord
On Sat, 13 Jan 2007 10:19:01 -0800, Tom Vandewiele
wrote:
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