+ Reply to Thread
Results 1 to 4 of 4

Help with timer events

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    205

    Help with timer events

    I'm creating a check off sheet.
    Beginning of the day, press the button and msgbox pops up reminding to check.
    Instead of using Now + (00.00***) or something like that, any other code that will make it pop up in another 5, 10, or 15mins?
    This mean, excel will be running in the background. Is this possible?

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Help with timer events

    Any reason you can't use the
    Application.OnTime Now+TimeValue("00:05:00"), "MyTimerRoutine"
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    205

    Re: Help with timer events

    I can, I want to go by time/clock not minutes/hours from NOW.
    I think I got it now using just
    Application.OnTime "16:00:00", "namehere" without the NOW+
    Thank you

  4. #4
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Help with timer events

    Yes, if you want a specific time, then you do not need the Now+. I may be wrong, but I don't think you can pass just the string, at least, I traditionally use TimeValue. So for 4pm:
    Application.OnTime TimeValue("16:00:00"), "namehere"

+ 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. need a timer
    By misterpeet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2014, 10:14 PM
  2. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  3. Timer
    By etsusurveyor in forum Excel General
    Replies: 1
    Last Post: 02-18-2008, 06:20 PM
  4. do events? background events
    By cereldine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2006, 08:10 AM
  5. Replies: 1
    Last Post: 03-10-2006, 08:10 AM

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