Select pictures from a sheet into an other sheet

[Pjotr70]

I just have p.a. 5 pictures in sheet 3 as a master.

In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special
place depending on a value in cell A1. With figures it is possible with
vloopup/hlookup but how to magae with pictures?

 

[Dave Peterson]

Not using a formula.

But you could use a macro.

JE McGimpsey shares how to do it with pictures:
http://www.mcgimpsey.com/excel/lookuppics.html

 

[Pjotr70]

Hello Dave, Thanks for your hind, I tried it at home but failed. Where do I
place the pictures? I tried to understand the example they give on there site
but couldntr changed it with my own pictures Can you help me?

Kind regards Pieter

 

[Dave Peterson]

You could put the pictures where they belong. JE's code toggles the visibility
of the pictures--not the locations.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Pjotr70]

Hello Dave,

Finally it works!! The JE's code must be placed in the background frm the
sheet you worked with. Thanks again !

 

[Dave Peterson]

The worksheet_calculate event fires when the worksheet that owns the code is
recalculated. So it has to be there.

Glad you found the solution.

Hello Dave,

Finally it works!! The JE's code must be placed in the background frm the
sheet you worked with. Thanks again !