I have created a worksheet that will provide sales details for 30
different retail locations. I select the store number and then the
sheet poplulates with all the individual data from a database contained
in the workbook.

Now I would like to have a different photo displayed on the same sheet
that coorelates to that store. I have 30 JPEGs and haven't been able
to figure out how I can get the image to switch when I select a
different store.

Is this even possible. I know it can be done in Access but I am
attempting to keep this project in Excel.

The only other alternative I have is to create 30 different tabs (one
for every store) and put a different photo on each tab. Not a very
friendly alternative because changes would be a pain. This sheet
already has five graphs that dynamically update.

Can anyone help.

Steve

The VBA solution provided by JE McGimpsey is the generally accepted best
approach:
http://www.mcgimpsey.com/excel/lookuppics.html

(There is an alternative non-VBA solution, though.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I have created a worksheet that will provide sales details for 30
different retail locations. I select the store number and then the
sheet poplulates with all the individual data from a database contained
in the workbook.

Now I would like to have a different photo displayed on the same sheet
that coorelates to that store. I have 30 JPEGs and haven't been able
to figure out how I can get the image to switch when I select a
different store.

Is this even possible. I know it can be done in Access but I am
attempting to keep this project in Excel.

The only other alternative I have is to create 30 different tabs (one
for every store) and put a different photo on each tab. Not a very
friendly alternative because changes would be a pain. This sheet
already has five graphs that dynamically update.

Can anyone help.

Steve