+ Reply to Thread
Results 1 to 13 of 13

Select Pictures In Drop Down List

  1. #1
    Registered User
    Join Date
    08-05-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Select Pictures In Drop Down List

    Hi There, Bit new to this but can anyone help me with some solutions to allow me to selcet a picture from a drop down list?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select Pictures In Drop Down List

    Hello GERZO,

    Welcome to the Forum.

    I am not sure how your WorkBook is setup, or what the layout looks like, but you could use the attached sample WorkBook as a start.

    Change it the way you like.

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Select Pictures In Drop Down List

    Hello Winon,
    How to change the pictures attached file.
    I want to add more my pictures.
    Thanks in advance for your help.
    Regards

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select Pictures In Drop Down List

    @ turist,

    Upload a WorkBook with all your pictures, and I will sort it out for you.

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Select Pictures In Drop Down List

    @ Winon

    My dear friend.

    If the OP has 200(or more) pictures?

    I believe that it's better to show to him(her) HOW can do it and not you to solve it for him(her).

    In any case, turistsee in this link how you can do this WITHOUT VBA. Using only formulae.

    http://www.youtube.com/watch?v=CEM0pp5SjMU
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  6. #6
    Registered User
    Join Date
    08-05-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Select Pictures In Drop Down List

    Perhaps someone can help me complete / copy the code for the workbook I attach

    T600 should select data from the same collum as T100 for example
    T2100 etc as per T1100
    T3400 etc as per T3100

    Hope someone can help on this one - Thanks


    Quote Originally Posted by Winon View Post
    @ turist,

    Upload a WorkBook with all your pictures, and I will sort it out for you.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-05-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Select Pictures In Drop Down List

    Perhaps someone can help me complete / copy the code for the workbook I attach

    T600 should select data from the same collum as T100 for example
    T2100 etc as per T1100
    T3400 etc as per T3100

    Hope someone can help on this one - Thanks


    Quote Originally Posted by Winon View Post
    @ turist,

    Upload a WorkBook with all your pictures, and I will sort it out for you.

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select Pictures In Drop Down List

    See Post #5 from Fotis1991.

  9. #9
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Select Pictures In Drop Down List

    Dear Winon,
    I want to learn how to place the pictures to the file.
    As Fotis1991 said , "it's better to show me HOW can I do it myself".

    Thanks for your patience and help.

    Regards.

    Quote Originally Posted by Winon View Post
    @ turist,

    Upload a WorkBook with all your pictures, and I will sort it out for you.

  10. #10
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Select Pictures In Drop Down List

    Dear Winon,
    I want to learn how to place the pictures to the file.
    As Fotis1991 said , "it's better to show me HOW can I do it myself".

    Thanks for your patience and help.

    Regards.

    Quote Originally Posted by Winon View Post
    @ turist,

    Upload a WorkBook with all your pictures, and I will sort it out for you.

  11. #11
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select Pictures In Drop Down List

    Hello turist,

    I want to learn how to place the pictures to the file.
    As Fotis1991 said , "it's better to show me HOW can I do it myself".
    Then have a look at the sample WorkBook in Post #2, and the link Fotis1991 has provided in Post #5 to do it without using VBA.

    I am sure you will come right on your own if you study these two ways of getting it done.

    Good luck!

  12. #12
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Select Pictures In Drop Down List

    Thanks dear Winon.
    I solved your attached file in Post#2 (Where code is : Me.Pictures.Visible = False)
    When changed as "Me.Pictures.Visible = True" , all pictures are shown on the page.

    Now I can manage my file.

    Thanks again for your guidance.

  13. #13
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Select Pictures In Drop Down List

    Hello turist,

    Good. I knew that you will get it right!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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