It is difficult to have animation within Excel. The only way I know is to use the Application.Wait Method. Unfortunately, this method is not foolproof. Sometimes it works just fine but sometimes it just doesn't work the way you would like.
The following "animated" utilities show how animation may work.