+ Reply to Thread
Results 1 to 3 of 3

Display picture for 5 seconds when specific text is entered

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    91

    Display picture for 5 seconds when specific text is entered

    I have searched the threads and found similar topics but none worked for me.
    I have a picture on sheet 2. When I enter the text "htfo" without the quotes into cells a1 on sheet 1 , i would like the picture to be displayed for 5 seconds and then exit the picture and return me to sheet 1. Thanks for any help

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Display picture for 5 seconds when specific text is entered

    Put this code under sheet 1 in Visual Basic Editor. I think it is what you are asking to do:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    91

    Re: Display picture for 5 seconds when specific text is entered

    That did it. Too simple. Thanks

+ 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: 08-05-2013, 07:32 PM
  2. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  3. Replies: 0
    Last Post: 09-04-2012, 03:18 PM
  4. Replies: 10
    Last Post: 11-21-2010, 10:38 AM
  5. Display Picture & Play Sound for 5 seconds
    By sisterwolf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2010, 01:58 PM

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