If then statements

[MarcB]

I'm sure this is possible, just not sure how I should go about it.
have a drop-down list with a bunch of values and an "other" value. I
the user selects other I would like a image to be inserted on anothe
worksheet in a field. If any value is selected I would like a simpl
text line to be inserted in the same area on the other worksheet.

How would I go about this? Should I code this in VBA or can it b
included in some sort of cell formula?

Thank you

 

[JE McGimpsey]

You'll need to use VBA. If you know a bit of VBA, you can probably adapt
this

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


If not, post back with a few more details...