+ Reply to Thread
Results 1 to 4 of 4

timer Macro

  1. #1
    Puzzled
    Guest

    timer Macro

    Looking for help in making a stop macro the below timer macro
    Timer works but seems to continue running

    Public Sub timer1()
    Application.OnTime Now + TimeValue("00:00:5"), "stop1"
    End Sub

    Thanks Leon

  2. #2
    Ian
    Guest

    Re: timer Macro

    I've not done much with OnTime, but with the help of this group I got the
    following line working.

    Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3),
    procedure:="UnhideColumns"

    --
    Ian
    --
    "Puzzled" <Puzzled@discussions.microsoft.com> wrote in message
    news:54056127-8348-47A0-B229-E22993F1B36D@microsoft.com...
    > Looking for help in making a stop macro the below timer macro
    > Timer works but seems to continue running
    >
    > Public Sub timer1()
    > Application.OnTime Now + TimeValue("00:00:5"), "stop1"
    > End Sub
    >
    > Thanks Leon




  3. #3
    Puzzled
    Guest

    Re: timer Macro

    Thank you

    "Ian" wrote:

    > I've not done much with OnTime, but with the help of this group I got the
    > following line working.
    >
    > Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3),
    > procedure:="UnhideColumns"
    >
    > --
    > Ian
    > --
    > "Puzzled" <Puzzled@discussions.microsoft.com> wrote in message
    > news:54056127-8348-47A0-B229-E22993F1B36D@microsoft.com...
    > > Looking for help in making a stop macro the below timer macro
    > > Timer works but seems to continue running
    > >
    > > Public Sub timer1()
    > > Application.OnTime Now + TimeValue("00:00:5"), "stop1"
    > > End Sub
    > >
    > > Thanks Leon

    >
    >
    >


  4. #4
    Ian
    Guest

    Re: timer Macro

    You're welcome. Nice to get the feedback.

    --
    Ian
    --
    "Puzzled" <Puzzled@discussions.microsoft.com> wrote in message
    news:C73CA14E-6C1B-4E71-A0C6-AC22AF2C4626@microsoft.com...
    > Thank you
    >
    > "Ian" wrote:
    >
    >> I've not done much with OnTime, but with the help of this group I got the
    >> following line working.
    >>
    >> Application.OnTime earliesttime:=Now + TimeSerial(0, 0, 3),
    >> procedure:="UnhideColumns"
    >>
    >> --
    >> Ian
    >> --
    >> "Puzzled" <Puzzled@discussions.microsoft.com> wrote in message
    >> news:54056127-8348-47A0-B229-E22993F1B36D@microsoft.com...
    >> > Looking for help in making a stop macro the below timer macro
    >> > Timer works but seems to continue running
    >> >
    >> > Public Sub timer1()
    >> > Application.OnTime Now + TimeValue("00:00:5"), "stop1"
    >> > End Sub
    >> >
    >> > Thanks Leon

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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