+ Reply to Thread
Results 1 to 14 of 14

how to make data validation list with pop-up image appear?

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    132

    how to make data validation list with pop-up image appear?

    hi guys,
    how to make data validation list with pop-up image appear?i knew how to insert image into comments box but had a problem when combining it with data validation list.anyone would help?Thanks.2arif.xlsm

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: how to make data validation list with pop-up image appear?

    I never seen using Pictures in Comment Box... Nice one... and it makes more sense when taking the mouse to the student name and it's showing the students pictures. really nice...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: how to make data validation list with pop-up image appear?

    would anyone help me?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: how to make data validation list with pop-up image appear?

    No you can't show the image along with DV list.....

  5. #5
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: how to make data validation list with pop-up image appear?

    any other ways?

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: how to make data validation list with pop-up image appear?

    Please wait I called all of the Experts/Gurus/Mod/Members help for this one.

    I am sure someone will surely suggest some method for you...

  7. #7
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: how to make data validation list with pop-up image appear?

    Hi pejoi..

    Check here..

    http://www.get-digital-help.com/2013...e-picture-vba/

    its another way to display picture according to selection..

    Your request is somehow match with this situation..

    just need to change Comment's background with image..

    Check by testing this..
    1st add a comment in B3, then start.. just for testing purpose..

    Please Login or Register  to view this content.
    Place the code in Sheet 2.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: how to make data validation list with pop-up image appear?

    @ Debraj Roy,

    Please correct me if I am wrong...

    I believe the OP wants to see the pictures alongwith the Drop Down names in the DV Drop Down list.

  9. #9
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: how to make data validation list with pop-up image appear?

    @ Sixthsense
    I think..

    OP wants to display Picture as comment . according to selected item.. in dropdown box..
    I mean.. if he choose name of any person then, comments background picture need to change to that person's picture..

    BTW.. I like the way you think..
    Are you thinking of Contact view in your phone.. Pic + name.. in the Dropdown list..
    something like Node (+ / - )

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: how to make data validation list with pop-up image appear?

    Oh! I was not thought in that way....

    Yes exactly your assumption is right...

    Sorry for the confusion too....

  11. #11
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: how to make data validation list with pop-up image appear?

    please elaborate further....i do not understand..

  12. #12
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: how to make data validation list with pop-up image appear?

    @debraj roy,
    you got the ideas...would you show me how to do it?thanks.

  13. #13
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: how to make data validation list with pop-up image appear?

    Hi pejoi..

    Sorry for late response..

    Please check the attached.. hope you are searching something like this..

    Please Login or Register  to view this content.
    Pic As Comment.zip

  14. #14
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: how to make data validation list with pop-up image appear?

    Hi pejoi..

    thanks for feedback.. (via PM)..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-28-2012, 07:46 PM
  2. Make a Data Validation List Grow With New Entries?
    By leaning in forum Excel General
    Replies: 7
    Last Post: 07-06-2010, 05:27 PM
  3. make fonts bigger in data validation\list box
    By janjan_376 in forum Excel General
    Replies: 2
    Last Post: 12-09-2009, 11:07 AM
  4. [SOLVED] How do I make a Validation List in Excel, using data on a second
    By Driver in forum Excel General
    Replies: 2
    Last Post: 02-23-2006, 09:35 AM
  5. Replies: 1
    Last Post: 09-29-2005, 04:05 PM

Tags for this Thread

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