+ Reply to Thread
Results 1 to 14 of 14

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

  1. 09-17-2013, 03:21 AM #1
    pejoi
    pejoi is offline
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    144

    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
    Reply With QuoteRegister To Reply
  2. 09-17-2013, 03:42 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    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
    Reply With QuoteRegister To Reply
  3. 09-17-2013, 03:50 AM #3
    pejoi
    pejoi is offline
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    144

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

    would anyone help me?
    Reply With QuoteRegister To Reply
  4. 09-17-2013, 03:53 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

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

    No you can't show the image along with DV list.....
    Reply With QuoteRegister To Reply
  5. 09-17-2013, 03:54 AM #5
    pejoi
    pejoi is offline
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    144

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

    any other ways?
    Reply With QuoteRegister To Reply
  6. 09-17-2013, 04:02 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    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...
    Reply With QuoteRegister To Reply
  7. 09-17-2013, 04:15 AM #7
    Debraj Roy
    Debraj Roy is offline
    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...
    Reply With QuoteRegister To Reply
  8. 09-17-2013, 05:00 AM #8
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    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.
    Reply With QuoteRegister To Reply
  9. 09-17-2013, 05:14 AM #9
    Debraj Roy
    Debraj Roy is offline
    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 (+ / - )
    Reply With QuoteRegister To Reply
  10. 09-17-2013, 05:39 AM #10
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    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....
    Reply With QuoteRegister To Reply
  11. 09-17-2013, 10:02 AM #11
    pejoi
    pejoi is offline
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    144

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

    please elaborate further....i do not understand..
    Reply With QuoteRegister To Reply
  12. 09-17-2013, 10:02 PM #12
    pejoi
    pejoi is offline
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    144

    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.
    Reply With QuoteRegister To Reply
  13. 09-18-2013, 07:24 AM #13
    Debraj Roy
    Debraj Roy is offline
    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
    Reply With QuoteRegister To Reply
  14. 09-18-2013, 09:52 AM #14
    Debraj Roy
    Debraj Roy is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make a drop down list (I.E. from Data Validation) that can also accept any value
    By benzle in forum Excel General
    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. [SOLVED] HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO
    By CHAIM in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1