Hi Marc

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"MarcB" wrote in message ...

I'm sure this is possible, just not sure how I should go about it. I
have a drop-down list with a bunch of values and an "other" value. If
the user selects other I would like a image to be inserted on another
worksheet in a field. If any value is selected I would like a simple
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 be
included in some sort of cell formula?

Thank you.


--
MarcB
------------------------------------------------------------------------
MarcB's Profile: http://www.excelforum.com/member.php...o&userid=14988
View this thread: http://www.excelforum.com/showthread...hreadid=277534