Can I make a picture change based on input from a user?

[Christop]

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?

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[Christop]

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.

 

[Dave Peterson]

It means that you didn't put the code in the correct location.

Rightclick on the worksheet tab that should have the behavior. Select view
code. And then paste the code into that newly opened code window (usually on
the righthand side).

Delete the code from whereever you put it before.

You'll notice that JE's code uses the worksheet_calculate event. That means it
runs automatically each time excel recalculates this sheet.

 

[Christop]

Excellent!!! Thank you so much, it is working now. My boss thinks I'm a genius!

 

[Gord Dibben]

But you will set him him straight when you show him JE's
website........right?


Gord Dibben MS Excel MVP