Select pictures from a sheet into an other sheet
 

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?

Select pictures from a sheet into an other sheet
 

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 wrote:

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

Select pictures from a sheet into an other sheet
 

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" wrote:

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 wrote:

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

Select pictures from a sheet into an other sheet
 

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 he
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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

Select pictures from a sheet into an other sheet
 

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" wrote:

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 he
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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

Select pictures from a sheet into an other sheet
 

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.

Pjotr70 wrote:

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" wrote:

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 he
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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson


--

Dave Peterson