No animation when you run VBA code to animate objects in Excel 2013


Assume that you run Microsoft Visual Basic for Applications (VBA) code that makes an object appear animated in Microsoft Excel 2013. However, you cannot see the transition between the starting position and the ending position of the object.


This issue occurs because the new graphics engine in Excel 2013 drops some frame requests when the VBA code sends lots of frame requests very quickly.


To work around this issue, add a DoEvents function before the loop that moves the object in the VBA code. This function will update the position of the object before the object moves to the next position.

More Information

The new graphics engine in Office 2013 provides smoother and more complex animations in the UI.

Id. de artículo: 2761182 - Última revisión: 12 oct. 2012 - Revisión: 1