I have this macro:
I'd like to add a 2 second delay after the above code is executed, then add the following code:Please Login or Register to view this content.
How could this be done? ThanksPlease Login or Register to view this content.
I have this macro:
I'd like to add a 2 second delay after the above code is executed, then add the following code:Please Login or Register to view this content.
How could this be done? ThanksPlease Login or Register to view this content.
Why do you need a delay?
Generally you can use this to add a delay https://msdn.microsoft.com/en-us/vba...t-method-excel
Its honestly not something you should do often as its a last resort. VBA is aware of its own process, so code doesnt generally execute until the prior code has completed.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Thank you. The purpose of the delay is to prevent Excel from hanging. If the first sub runs then Excel "works" a few seconds, completing several data queries.
I don't want to do a refresh until the data queries have run.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks