Change picture in image control based on cell values.

[Rberg365]

I am having a major issue with this.

Currently, I have several figures inserted into my workbook and have defined names for them all. Also, I use several drop down menus and decisions to come with a final name. This name is in the cell Information!F3 . Now, I want to display a different figure depending on which name is displayed in F3.

Additionally, there is the chance that this workbook could between computers, so I would like to avoid having a file directory path. Is this possible?

-Thanks
Rob

[Ron Coderre]

I attached a demo file that shows how to display pictures based on the value of a dropdown list, without VBA code. Does that get you headed in the right direction?