There are 9 Data Validation drop down menus in column A. Each one uses the same list on Sheet2 Column D
What I want is when a name is chosen from one of the menus, the corresponding picture will appear.
The images are in a separate folder called Photos.
I have a macro to make the pictures appear, which is called Test.
I've included the file.
Bookmarks