rotating shapes

[Stanley91]

Hi I've been trying to get this workbook (attached) working for a while now with little success. I want __bar_1 to stay connected to __point_1 when the button "play" is pressed .

Also is there a way the rotation could be set in terms of time where I could set say k3 to 50 seconds and the bars would rotate for that amount of time

any help would be much appreciated, struggling big time to figure this out.

moving_shapes.xlsm

[Andy Pope]

You need to recalculate the connection point of the second bar because that changes at each rotation increment.

The for loop is now a do loop based on number of seconds enter in named cell, [Duration].
The stop button also now works as STOP is entered in to named cell, [STOP_ANI], and the code checks for that whilst looping

[Stanley91]

Thanks a million Andy! that's brilliant!