Gary

Maybe you can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics.

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


Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 06:24:03 -0700, Garyw
wrote:

I know just enough about Visual Basic to make me dangerous.
Would you please write a complete sample code that I might
run it and try to understand how it works. Then next time I come
to a problem like this I'll know what to do.

Thanks....