Results 1 to 3 of 3

Application OnTime Error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    274

    Application OnTime Error

    When the following code runs, I get an error (Method of "OnTime" object failed) on the line where "Schedule=:False". Why am I getting this error:
    i = i + 1
      ActiveSheet.Cells(2, 2) = CStr(i)
      Application.OnTime Now + TimeValue("00:01:00"), "RunTime"
      'On Error Resume Next
      Application.OnTime Now + TimeValue("00:00:05"), "RunTime", Schedule:=False
    Last edited by alansidman; 09-24-2016 at 09:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Turn off Application.Ontime when Error occurs
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2016, 03:53 AM
  2. VBA - Application.Ontime Cancel Fails to Method 'ONTIME' of Object 'Application'
    By LordAzuRa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 03:21 PM
  3. [SOLVED] Cancelling Application.ontime Error 1004
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2015, 08:24 AM
  4. [SOLVED] 1004 error when using application.ontime
    By gdecker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 12:52 PM
  5. Error with application.ontime...macro runs twice next day..
    By gokzee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 11:41 PM
  6. [SOLVED] VBA macro application.ontime timevalue error
    By Jack7774 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-05-2013, 11:58 AM
  7. [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

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