+ Reply to Thread
Results 1 to 5 of 5

Comment Picture with List Data Validation

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Comment Picture with List Data Validation

    Hello,

    My goal is to have a picture pop up (preferably for a set amount of time), when a user selects a certain option from a data validation drop down list.

    I have seen that you can add a picture to a comment, bu I can't combine comments with data validation lists.

    Is there any way to get a comment to be part of a data validation list? Or any other way to solve my problem?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Comment Picture with List Data Validation

    Here is a simple macro-enabled example. The DV pull-down is in cell C11.
    Attached Files Attached Files
    Gary's Student

  3. #3
    Registered User
    Join Date
    07-26-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Re: Comment Picture with List Data Validation

    Thank you so much - that's fantastic. Is there any simple way to make the picture only appear for a few seconds?

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Comment Picture with List Data Validation

    Yes............we would need to include an OnTime macro.

  5. #5
    Registered User
    Join Date
    07-26-2014
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    3

    Re: Comment Picture with List Data Validation

    Ok thanks, I will have a look into that

+ 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. Inserting Picture into Comment and re-sizing to fit chosen picture
    By ericmartin.hr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2014, 01:53 AM
  2. Replies: 9
    Last Post: 05-22-2011, 09:26 AM
  3. Replies: 3
    Last Post: 04-11-2011, 05:52 PM
  4. Getting data from a cell into a comment or data validation text
    By steve.g in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-27-2010, 03:34 AM
  5. Picture in comment box
    By Peter Andrews in forum Excel General
    Replies: 2
    Last Post: 02-07-2006, 05:10 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