Results 1 to 2 of 2

Application.wait

This is a discussion on Application.wait within the Excel Questions forums, part of the Question Forums category; Hi Application.Wait (Now + TimeValue("0:00:1")) delays the code for a second. Is there any way i can get this to ...

  1. #1
    Board Regular
    Join Date
    Jun 2003
    Location
    Pakistan
    Posts
    130

    Default Application.wait

    Hi

    Application.Wait (Now + TimeValue("0:00:1")) delays the code for a second.

    Is there any way i can get this to dalay for half a sec ?

    Regards
    Asim

  2. #2

    Join Date
    Sep 2003
    Posts
    994

    Default Re: Application.wait

    Why do you need to do this?

    I'm not sure that XL can operate to such accuracy.

    Running your code "Application.Wait (Now + TimeValue("0:00:1"))" seven times produced run times (in seconds) of :-

    0.60
    0.94
    0.06
    0.93
    0.66
    0.55
    0.28

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com