I tried copying his macro to my worksheet and get a error
"invalid use of Me. keyword".

I am fairly new to macros and don't know what this means.


"Pete_UK" wrote:

Take a look at this, from John McGimpsey's site:

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

Hope this helps.

Pete

On Sep 24, 3:26 pm, Christop
wrote:
I am creating a spreadsheet with a dropdown list of options for house
floorplans. I would like for a small drawing to pop up to the side to
illustrate. I can create the plan as a jpeg, tif, or about any other pic
format.

Any suggestions?