Hi...
Meet me again ;)
Now I want show for you a tutorial how make basic animation with VBA Excel and I hope this can help you to expansion animation on VBA Excel.
Sub Play_Click()
x = 0
Do
DoEvents
x = x + 2
Sheet1.Shapes("Bola").Left = x
Sheet1.Shapes("Bola").Rotation = x
Loop Until x = 522 Or s
Do
DoEvents
x = x - 0.5
Sheet1.Shapes("Bola").Left = x
Sheet1.Shapes("Bola").Rotation = x
Loop Until x = 500
End Sub
Sub Stop_Click()
s = 0
End
End Sub
Animation Finish and click shape "Play" to Run
END
Ok, thank you for visit @khaidir22 please vote me and see you.
;)