I have a worksheet that displays the performance for a single retail
outlet. I change the location name and via lookups I change the data
in the worksheet to reflect the sale performance for the new location.

I would like to have a unique photo of each retail location when I
select a different location.

Is there any way to programmatically have a new photo automatically
display when a new location is selected?

Steve Sammons

Steve

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a value in a cell.

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


Gord Dibben MS Excel MVP

On 30 Nov 2006 08:49:52 -0800, "Steve" wrote:

I have a worksheet that displays the performance for a single retail
outlet. I change the location name and via lookups I change the data
in the worksheet to reflect the sale performance for the new location.

I would like to have a unique photo of each retail location when I
select a different location.

Is there any way to programmatically have a new photo automatically
display when a new location is selected?

Steve Sammons

Gord:

This is wonderful! However, when I paste the code into my worksheet and
begin putting it together I get a runtime error "Unable to set the
Visual property of the Picture class".

The debugger highlights the line that contains "Me.Pictures.Visible =
False"

Any thoughts?

Steve

Gord Dibben wrote:
Steve

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a value in a cell.

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


Gord Dibben MS Excel MVP

On 30 Nov 2006 08:49:52 -0800, "Steve" wrote:

I have a worksheet that displays the performance for a single retail
outlet. I change the location name and via lookups I change the data
in the worksheet to reflect the sale performance for the new location.

I would like to have a unique photo of each retail location when I
select a different location.

Is there any way to programmatically have a new photo automatically
display when a new location is selected?

Steve Sammons

Steve

Do you have pictures on the worksheet?

Have you got the lookup table on sheet2?

If you didn't download JE's example file you should do so to see how he has it
set up.

His workbook does as advertised.


Gord


On 30 Nov 2006 13:54:49 -0800, "Steve" wrote:

Gord:

This is wonderful! However, when I paste the code into my worksheet and
begin putting it together I get a runtime error "Unable to set the
Visual property of the Picture class".

The debugger highlights the line that contains "Me.Pictures.Visible =
False"

Any thoughts?

Steve

Gord Dibben wrote:
Steve

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a value in a cell.

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


Gord Dibben MS Excel MVP

On 30 Nov 2006 08:49:52 -0800, "Steve" wrote:

I have a worksheet that displays the performance for a single retail
outlet. I change the location name and via lookups I change the data
in the worksheet to reflect the sale performance for the new location.

I would like to have a unique photo of each retail location when I
select a different location.

Is there any way to programmatically have a new photo automatically
display when a new location is selected?

Steve Sammons

I do have the lookup table on a sheet 2 and I do have the images on the
sheet that has the formula. If I asterisk out the "Me.Pictures.Visible
= False" it works. The only problem is that all the images are visible
and the order of the photos doesn't change. Everything works...I
just can't make all the images disappear. On this same sheet are
several other Graphs but I inserted a bunch of graphs into the sample
file and that didn't mess things up. I have removed all the photos and
put new ones in to see if there was an issue with the property of the
images. None of these tactics has led to success.

Any thoughts?

Steve

And I have downloaded JE file and it works fine. I also moved the two
sheets from his file over to the file that I am working on to see if it
would work there and it does. But my master sheet doesn't like the
hide pictures line at all.