Images in excel drop list??

**defy** · 05-19-2009, 07:54 AM

Is it possible to get an image to come up if an item is selected from a drop list? (The image must come up beside the list and all the images are stored in the same book)

Also is it possible to reset all the fields to blank after the user has finished picking his selection? (What I mean is I have an inter linked list i.e. pick department-->pick device-->pick cable)

**defy** · 05-19-2009, 10:24 AM

No worries figured it out :D

**LotusMan333** · 05-19-2009, 10:41 AM

How did you do it?

**contaminated** · 05-19-2009, 01:33 PM

Yes it is possibe

Do selection from A1 of sheet2

Instructions:

1.Place 3 pics in blank sheet, so that they would fit row heigh and column width
2.Type this formula for dynamic validation list
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A))
Copy it and go to insert> name >define, paste it in reference field and name it as "Names"
3. Create valdation list (DATA> VALIDATION>LISTPRESS F3 and select named formula.
4. Type =OFFSET(Sheet1!$B$1,MATCH(Sheet2!$A$1,Sheet1!$A:$A,0)-1,,,) and name it (go to insert> name >define) "pictures"
5. Hold shift key and go to Edit menu. There must appear new unseen before command "Copy Picture". Then paste it in the sheet where validation list is,
6. Select pasted pic and in formula bar type =pictures