+ Reply to Thread
Results 1 to 2 of 2

Using several Data Validation menus to show one picture

  1. #1
    Registered User
    Join Date
    Atlanta GA
    MS-Off Ver

    Using several Data Validation menus to show one picture

    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.
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    Tysons Corner, VA, USA
    MS-Off Ver
    2013, 2016

    Re: Using several Data Validation menus to show one picture

    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.
    Attached Files Attached Files

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you please click on the star icon at the bottom of their post
    If your problem is solved please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1