Have a look at the example workbook that Bernie Dietrick devised.

Allows for multiple DV dropdowns with multiple pictures associated with each.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 03:07:01 -0700, Faiek
wrote:

This is fantastic

This will really help me !!
Can this be done across three drop down list?

Thanx Gary's Student

"Gary''s Student" wrote:

See:

http://www.mcgimpsey.com/excel/lookuppics.html
--
Gary''s Student - gsnu200784


"Faiek" wrote:

I dont know if this can be done, but
If I have two or more drop down list populated in a particular way I need a
picture to reflect .

Can this be done?