+ Reply to Thread
Results 1 to 4 of 4

Time Delay

  1. #1
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Time Delay

    Hi Gents,

    I use the code below to delay the time from the next picture that will be shown.
    Please Login or Register  to view this content.
    The problem is all the calculation will be freeze as long as the timer delay is starting.

    Is there any code to show the next picture which the calculation will be not freezing?

    Thanks in advance for any helps.

    Cheers,
    Iqballhud
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Time Delay


    Hi !

    Maybe via OnTime method, to see in VBA inner help …

  3. #3
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Time Delay

    Hi Marc,

    I was trying to write the code, unfortunately that was not working fine.
    Maybe I don't know how to write the code properly..
    Please Login or Register  to view this content.
    Thanks for your advice Marc.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Time Delay


    In your main procedure, just call only an unique OnTime procedure in order to load next image.
    Within the OnTime procedure, after loading an image use OnTime statement to setup next call of this OnTime procedure …

+ 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. [SOLVED] What the code to set Time Delay?
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2014, 02:53 AM
  2. Time delay in a particular cell
    By bhushanvshah in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2014, 09:20 PM
  3. time delay in a macro
    By thesnake505 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2013, 07:43 PM
  4. [SOLVED] Time delay to run code
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2012, 03:54 PM
  5. delay time calculate
    By johncena in forum Excel General
    Replies: 18
    Last Post: 05-24-2010, 12:54 AM
  6. Time Delay while able to use spreadsheet
    By Ada01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2009, 11:16 AM
  7. Macro Time Delay
    By phil2006 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2008, 05:26 PM
  8. Time Delay Reset
    By CJ-22 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-04-2006, 09:29 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