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