I have a macro that selects a picture in the middle. I want the macro to wait 5 seconds before it runs the next code. I've achieved the basic effect by looping meaningless code, however, would anyone know the more correct way to approach this?
I have a macro that selects a picture in the middle. I want the macro to wait 5 seconds before it runs the next code. I've achieved the basic effect by looping meaningless code, however, would anyone know the more correct way to approach this?
Application.Wait(Now + TimeValue("0:00:05"))
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Yes!!!!! That works perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks