Excel

Userform - animating an icon to the Userform, Taskbar and System Tray

Ivan F Moala

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: August 26, 2007

Some time ago I showed how to put an icon on a userform and also place it in the Taskbar as well as the System Tray.

Here I show how to animate an icon and use this for the userform, taskbar and system tray.

The technique relies on;

1) API Timer or here which users the Addressof function so you must use XL2000 onwards.

2) ImageList control (I am not sure what versions this is available from but I beleive it is 2000 onwards.

For the icon I used an animated icon and extracted out the icons image for each rotation using IrfanView version 3.98. (highly recommended) You can use what ever gets the same. I use to use the old Paintshop Pro :)

NB: Workbook NOT AVAIL YET!

Download now..............

This page was created 27th April 2007

Can Do

The above image is an example workbook that creates the animated icon and shows you how to do this.

Download example of the above now..............

PLEASE NOTE:

This workbook also uses a technique that renders the workbook as a stand alone, ie opening other Excel workbooks will NOT open in this instance of Excel.

What this means is that you can use this as a Stand Alone.

The code for this is;

'// Make sure the UF acts independent of Excel

With Application

.UserControl = False

.IgnoreRemoteRequests = True

End With

Coming soon....... see below

The above workbook is still in progress

I will update here soon...........