It is possible to select a value from a dropdown list and have an image
returned.

Other way round is not possible in a dropdown list.


Gord Dibben MS Excel MVP

On Fri, 7 Aug 2009 00:01:03 -0700, SandraG
wrote:

Hi, I work in a school where I need to make point sheet for young children to
take home. I found your posting "is it possible to create a dropdown list
with picture/icons?" I was really excited to see this. However I was unable
to get this to work. I also wanted to take it a step more. I need three
expressions a smile, ok, and a frown. Each smiley needs to equal a value. the
smile-5, ok = 2.5 and frown=0. I need the value I pick to be added with other
columes to give me a total for the students day (placed at the bottom of the
chart.) Any Ideas on how this can be done?

Sandra

"Tom Vandewiele" 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