Scott

Would require Worksheet event code to do this.

Se JE McGimpsey's site for instructions.

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


Gord Dibben Excel MVP

On 16 Feb 2005 07:35:15 -0800, (Scott) wrote:

is there a way to write a statement in Excel (like an IF Statement),
that would display a
specific picture if a certain #/word/etc is typed in a cell? For
example in A1 if I typed in ball, it would automatically bring up a
pic
I have saved of a ball in B1, whereas if I typed dog, it would put a
dog in B1, etc..? If you know how to do this can you PLEASE email me
at as its hard for me to check the Ngs at work...
Thanks in advance
Scott