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.
You did not specify the relationship between the names in the sheet and file names for the photos, so I assumed they are the same.
I can't test this without your photos.
But give this a try.
Also I moved your thread from Excel - New Users/Basics since this is a VBA problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks