Excel

Following on from the cmctrl32.dll and the progressbar control, here is another useful control that is defined in User32.dll, Comctl32.dll, and Windows UI elements. Specifically, it supports the following types of UI elements (listed by Windows class name). In this case we are looking at the animation control.

Windows class name	UI element type
ListBox	List boxes
Button	Push buttons, radio buttons, check buttons, group boxes
Static	Labels
Edit	Text boxes
ComboBox	Combo boxes, drop-down lists
ScrollBar	Scroll bars
#32768	USER menus
#32770	USER dialog boxes
#32771	Alt-tab window
msctls_statusbar32	Status bars
msctls_progress32	Progress bars
msctls_hotkey32	Hot key controls
msctls_trackbar32	Trackbars, sliders
msctls_updown32	Up-down or spin controls
SysAnimate32	Animation control	<<<
SysTabControl32	Tab control
SysHeader32	List view headers
SysListView32	List view controls
SysTreeView32	Tree view controls
SysDateTimePick32	Date and/or time picker
SysIPAddress32	IP address controls
tooltips_class32	ToolTips
ToolbarWindow32	Toolbars
RICHEDIT, RichEdit20A, RichEdit20W	Text fields

AVI files (Audio Video Interleave, the file format for Microsoft's Video for Windows standard) can be useful when you need to display an animation in a Window. In this case I have done this for a userform, but you can just as easily do it within the Excel application, all you need is the handle to the window.

Many people have wanted to show some sought of animation within there userfrom. Here is one way to do this.