Excel -- Can A Drop Down List Select A Graphic 1

[rjm65]

I have a worksheet that has a drop down list with 6 choices. I would like a graphic (jpg, gif or bmp)to appear on the worksheet that matches the choice selected in the drop down list. Is this within the capabilities of Excel?

 

[SkipVought]

1) put each graphic in a cell in a single column along with the text that you want in the drop down

2) size the cell & pic to be identical in width & height

3) be sure the pics format property is MOVE & SIZE with cell

4) add a heading row if you don't have one.

5) toggle on the AutoFilter

6) Select one of your pics

VOLA!

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}