Application.Wait Now + TimeSerial()

  • Hi


    I am using Application.Wait Now + TimeSerial() function to give my computer some time after clicking on a tab and add-in to retrieve some data.
    When I run it I can see the mouse goes to the positions required but it doesn't click it until the end of the macro and then clicks them all at once.


    Any idea why or how can I fix this problem. Maybe I can use some other functions instead?


    Thank you

  • Welcome to the forum!


    DoEvents might help.


    Sounds like you are using SendKeys(). If so, it is all about timing and focus. Set wait routines may work but it is better to code in infinite loops until focus is where it is needed.