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. Dec 30th, 2003, 05:15 AM #1
    masim
    masim is offline
    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
    Reply With Quote Reply With Quote
  2. Dec 30th, 2003, 06:02 AM #2
    Ponsy Nob.
    Ponsy Nob. is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


DMCA.com