I have a dropdown list that I can choose from. The values on the worksheet
change depending on the choice. I want to also have a graphic that relates
to each selection. (These are small room plans - EMF files). Is there any
way I can link to different files based on a formula? Alternatively, I could
insert all the EMF files (not as desirable, but acceptable) into the Excel
file and have them called up based on the selection, or put them all on top
of eachother and have them somehow all hide except for the selected one.