I am trying to move a picture and then make the code sleep for a while. The problem is, the position of the picture does not update before “sleeping”. Here is the code:
Worksheets("Sheet1").Shapes("Picture1").IncrementLeft 100 Sleep 500
When I execute this code(the sub is called by a button), the position of the picture does not change until the end of “sleep 500”.
How can I update the picture before sleep? I will be much appreciated if you can also explain this to me.