(Solved) – How to update the image before sleep?

  • by

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.

Leave a Reply

Your email address will not be published. Required fields are marked *