Results 1 to 3 of 3

Application.OnTime, Not Start, EveryTime ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Lightbulb Application.OnTime, Not Start, EveryTime ?

    Hi Gurus

    Have 7 Macros waiting to run "Application.OnTime TimeValue(Range("$X$9").Text), "WebPull"

    Sometimes they run
    Sometimes they don't

    Looking on the Net came across

    "if meanwhile another procedure is being executed and Excel is not in ready mode within 20 seconds, this procedure will not run."

    "This means that the time when the procedure is to run (EarliestTime argument) should be assigned to a variable"

    Trouble is me not know how to set up variables

    Any assistance greatly appreciated as always you da men

    Mike : )


    Sub settimers()
    
    
    
    Call WebPullOne  'Initial 1st Call
    
      Call Macro58   'Light Says Go and Stop at set time has been pushed
    
    
    
        Application.OnTime TimeValue(Range("$X$9").Text), "StartBlink"    '  When Webpull starts
        
          Application.OnTime TimeValue(Range("$x$10").Text), "OneOne"    '  Start 
        
            Application.OnTime TimeValue(Range("$Z$11").Text), "JR_Cell_B10_Test_Run"    '  Start 
        
              Application.OnTime TimeValue(Range("$Z$12").Text), "JR_Cell_B10_Test_Run2"    '  Start 
        
                Application.OnTime TimeValue(Range("$X$3").Text), "OffEditQuery"    'EveryThing
    
                  Application.OnTime TimeValue(Range("$X$9").Text), "WebPull"    '  Main Set to 1 Min refreshes
    
                    Application.OnTime TimeValue(Range("$W$11").Text), "StopBlink"    'When Webpull stops
                    
                      Call Recalc 'Starts Count own Clock
    
    
    End Sub
    Last edited by keen2xl; 10-26-2013 at 03:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Application.ontime
    By hatrickx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 09:18 PM
  2. [SOLVED] Application.OnTime VBA
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2013, 05:41 PM
  3. [SOLVED] Help with Application.OnTime (was Application.Wait Now)
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-29-2012, 01:18 PM
  4. Application.OnTime
    By albatross32 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-17-2011, 03:15 PM
  5. [SOLVED] application.ontime
    By rick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2005, 02: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