Refresh/Update Shapes while running macro

[sourabhg98]

Hello Everyone,
I was making a sort of animation of a moving triangle in excel. For the same I was able to make this (check attached)-

This is the macro I am using-

The only problem is that this macro doesn't update the coordinates of the shape.
In detail, the macro puts a value in cell B1 from 1 to 50. For every value a new set of coordinates are obtained in A4 to F4. I want the macro to plot a triangle with each of those 50 coordinates obtained, and delete the previous triangle, so that it creates a sort of animation of a moving triangle. But the macro doesn't refresh the shape with new coordinates and I end up having the last triangle i.e. 50th triangle.

Please help me!!!!

I just need something to refresh the shapes each time new coordinates are obtained.
Do ask if anything seems to be confusing.

Thank You so much in advance!!

[Andy Pope]

DoEvents will allow the shape to be refreshed.
You will also need something to delay the speed with which the loop executes otherwise the animation will be too quick

Please Login or Register  to view this content.

[sourabhg98]

Thank you so much!!!!!!!!
This was exactly what I was looking for!!!!

[sourabhg98]

Hello again Sir,

I tried executing the code provided by you in my actual project but it doesn't seem to work there.

Please Login or Register  to view this content.

(Check Module 2- Sub Revolve)
This was the code provided by you which worked perfectly in the case of the triangle, but its not working here. Only the last coordinates are plotted and no sort of animation is done here.
I tried increasing the time of sleep so that tasks could be completed in that time but in vein.

I am successful in calculating all the coordinates and just need assistance for "Sleep and Do events part".

I will be extremely grateful to you if you could once again assist me it accomplishing this.

Thanks a lot again!!!!

[Andy Pope]

Double up on the Doevents command

Please Login or Register  to view this content.

Even then the cube only move partially, but you can see it moving

[sourabhg98]

That was all I needed!!!!!!

Again thanks a tonne!!!!!!!!
I really appreciate your assistance!